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!

  • Congratulations strongm 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: *

  • Users: pcaok
  • Order by date
  1. pcaok

    would I use a macro or formula for this scenario...

    On Sheet1!A1, a numerical value is entered. This value is linked to Sheet2, cell A1. The next time a number is entered on sheet1!A1, the value would be displayed on Sheet2!A2. Everytime a number is entered on Sheet1!A1, it will increment to the next empty cell on Sheet2!A Any help would be...
  2. pcaok

    Renaming files

    I don't know how this happened, but I had backed up my important folders on a D Partition before replacing Windows ME with Windows 98. ( I know, probably should have gone to XP). After a fresh 98 OS, I restored the files on D to folders on C, and noticed that after each file extension was a...
  3. pcaok

    moving data from rows to colums

    Thanks for your input Rick. I loaded the code...and the columns moved, and the rows deleted, but the phone number didn't move. I'll look through it and see if its a small change though. Thanks again !
  4. pcaok

    moving data from rows to colums

    Rick, thanks for your help. I am a "newbie" at this though.... I tried going through the VBA help, and really didn't know where to start. Actually, what I'm wanting to do is import these addresses into a database, and to also create mailing labels. I have fax numbers to add, as well...
  5. pcaok

    moving data from rows to colums

    An Excel Spreadsheet Question Example: A B C ______________________________________________________________________ 1 Joes Market 865-123-2345 2 123 Willow Way 3...
  6. pcaok

    can i copy only part of a cell to another?

    Example: a cells contents is a text string followed by a phone number. The phone number will always be xxx-xxx-xxxx (area code, and then the number). What would I have to do to create a macro to move the phone number only, out of the cell, to the next cell over... (text and phone number...

Part and Inventory Search

Back
Top