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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- pcaok
- Thread
- Replies: 6
- Forum: Microsoft: Office
-
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...- pcaok
- Thread
- Replies: 3
- Forum: Microsoft: Windows
-
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...- pcaok
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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...- pcaok
- Thread
- Replies: 3
- Forum: Microsoft: Office
