Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find All and then Copy the Data...
I have a sheet setup that is a list of people who have signed things out from our office. It includes date/timestamp information, user IDs, and items borrowed
I want a way to put someone's ID in a box and have it then do a search and if it finds that ID in the list, it would Copy the whole row (just to make it easier) onto a new Sheet. This I can do However, I then want it to continue through the sheet looking for more instances of the text and to continue to copy the data for all rows where it finds the person's ID. Basically to pull a history for the user and see what they have checked out and when How would I do the command (or loop) to repeat the search until it hits the end of the data Can I somehow put a set VAR = cells.find... inside of a loop and say Search, copy data, search again, until it doesn't find it Any guidance would be great |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and copy data between () | Excel Discussion (Misc queries) | |||
Find and copy data | Excel Worksheet Functions | |||
find last row and copy previous row data | Excel Worksheet Functions | |||
Find & Copy Data query | Excel Discussion (Misc queries) | |||
Can Excel Find and Copy a row of data? | Excel Worksheet Functions |