Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search and copy text from one sheet to others
I would like to copy cells from one worksheet to other worksheets where a
portion of the value matches. I have one file with several worksheet tabs. Example: Dept 1 - Members, Dept 2 - Members...Dept 30 - Members Sheets 2, 3 ,4 must not be included in formula (I can move them to new file if needed) All the sheets only have Data in column A and data starts on row 1 Dept 1 - Members column A looks like this: (abc-username) abc-smithb abc-yeltzb acb-zooa all the other sheets look like this (username) smithb yeltzb zooa I need to take the user in column A of Dept 1 - Members sheet and populate column B where ever his username appears in all the other sheets (it could be on multiple sheets). result should look like Dept 12 - Members sheet column A Column B smithb abc-smithb yeltzb abc-yeltzb zooa acb-zooa Dept 14 - Members smithb abc-smithb yeltzb abc-yeltzb zooa acb-zooa The sheet "Dept 1 - Members" should remove the abc-username from that sheet only and data be consolidated to eliminate empty rows. The abc-username should only be removed if a match is found on another sheet. Also, I would need to know how to enter the function/script in to excel 2003. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search for rows in one sheet and copy into another sheet based on customer id | Excel Worksheet Functions | |||
How to search column, copy row, and copy to another sheet in same | Excel Discussion (Misc queries) | |||
Search and copy certain text | Excel Discussion (Misc queries) | |||
How to search and copy cell content to another sheet? | Excel Worksheet Functions | |||
SEARCH COPY OF TEXT | Excel Discussion (Misc queries) |