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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by gestaltphoenix

  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

    xlbo No offence taken... As it stands, my working knowledge of Excel is limited to the point where I wouldnt know where to start looking, leading me to put myself at the mercy of the forum experts. Whilst many beginners could find the answers on their own by looking things up, it is...
  3. gestaltphoenix

    extracting partial cell value

    Thanx for the help combo, et al... And xlbo, as described at the bottom of this very page, "DESCRIPTION: Microsoft: Office technical support forum and mutual help system for computer professionals" I had a task, I needed help. If you dont like the question, don't answer...
  4. 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...
  5. gestaltphoenix

    Move cell to top of unknown column w/irregular blanks

    dale, Thanx a lot...still learnin some of the syntax...worked like a charm... GP
  6. 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...
  7. 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...
  8. gestaltphoenix

    Database Design Suggestions Needed

    'smudge, Nice perspective....I think I've been staring at this for too long :)...I think I can definitely use this! Thanks for the help! Regards, gestaltphoenix
  9. gestaltphoenix

    Excel Multiple Merge Issues

    Hasit... Many thanx for the quick response... Pardon my ignorance, but doesn't Access 2000 support SQL queries? Also, if you have a minute, I'd be interested in a summary of how you designed that access dbase. I'll be working with up to 10,000 different codes, each of which has about 20...
  10. gestaltphoenix

    Database Design Suggestions Badly Needed!

    Bastien, Many thanx for the speedy reply... It is definitely two rows....its not a spillover... (i.e. A2="Material" A3="Code") If I'm going to do this in Access, that is still a big problem....If it truncates the titles by taking the bottom cell only, then fields like PEC...
  11. 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...
  12. 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...
  13. 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...
  14. 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
See more

Part and Inventory Search

Back
Top