Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gestaltphoenix

    Query exporting blank...

    Hello... I've been running queries all day, and exporting them to excel spreadsheets with no problem. For this last problem, I have a query that shows all the necessary information in the Access table, but when exports to spreadsheet, it writes only the column headers and nothing else. Anyone...
  2. gestaltphoenix

    extracting partial cell value

    Hey all... I know this is probably basic but I'm a little pressed for time to look it up at the moment. I have a cell value in the format as follows: (194) 3151-05B PAR TELSET MLS 12B BLK 7311H05A How can I write a formula that will extract just the number in parantheses? The numbers change...
  3. gestaltphoenix

    Move cell to top of unknown column w/irregular blanks

    Hey ppl, I have a script running where information is filled into columns and rows dynamicly, meaning if certain criteria is checked off then it will appear in the next unused column. This means I dont know what column I'm going to be in when I need to move to the top of it in to fill in a...
  4. gestaltphoenix

    Excel VBA syntax question...

    Hey all... I'm a bit new to VBA so bear with me... I currently using a UserForm to have people input 5 different spreadsheets that will be merged. I used the GetOpenFile method to store the filepaths & filenames in a variable so I could open the spreadsheet by using the...
  5. gestaltphoenix

    Excel Multiple Merge Issues

    Ok, heres the deal... I have 3 different Excel reports coming from our SAP database that I need to merge into 1 customized report. In other words, with reports A,B, & C, I need to to merge parts of B&C into A. All 3 reports have a particular column (Material Codes) that need be merged with...
  6. gestaltphoenix

    Database Design Suggestions Badly Needed!

    Ok, heres the deal... I have 3 different Excel reports coming from our SAP database that I need to merge into 1 customized report. In other words, with reports A,B, & C, I need to to merge parts of B&C into A. All 3 reports have a particular column (Material Codes) that need be merged with...
  7. gestaltphoenix

    Database Design Suggestions Needed

    Ok, heres the deal... I have 3 different Excel reports coming from our SAP database that I need to merge into 1 customized report. In other words, with reports A,B, & C, I need to to merge parts of B&C into A. All 3 reports have a particular column (Material Codes) that need be merged with...
  8. gestaltphoenix

    noob question: using a form to import spreadsheet?

    Suggestions on how to import a spreadsheet by typing the file path into the text box. A browse button would be even nicer :o)....Any suggestions??? Sorry for the noob question.... Thanx

Part and Inventory Search

Back
Top