Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unique ID on different sheets
Hi All
Tis the season of goodwill perhaps all you experts out there will help with my small problem. Several days a week I receive emails in the following format 4161,WM2899 ,140,84 I have no problem copying and pasting in column A of Sheet1 then Text to Columns I may have as many as 400 rows as above all will be different the 1st 4 digits 4161 are of no use whatsoever so they have to be deleted -- WM2899 is the ID number and could be anywhere in Column A on any of the 30 other sheets in the workbook all with different names on finding the ID number on whatever sheet or row I need the digits 140 to enter the 1st empty Column Cell on the row the ID number is found -- Likewise the digits 84 in the next empty column cell adjacent to the 140. If a macro can do this I would place a command button on Sheet 1 and assign the macro. Any help much appreciated -- Many Thanks Sue |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple sheets, one user form, and a unique ID | Excel Programming | |||
Extract Rows Unique to Two Sheets | Excel Discussion (Misc queries) | |||
Selecting sheets with unique names | Excel Programming | |||
Find Unique Records from two sheets | Excel Programming | |||
defining unique range of cells for different sheets as the same n. | Excel Discussion (Misc queries) |