MrExcel Publishing
Your One Stop for Excel Tips & Solutions

copy rows containing specific data to a new worksheet


Posted by Lori D on August 30, 2001 8:05 AM

I have a spreadsheet that tracks data for over 50 locations. It is updated daily, and the order inwhich it gets entered is completely random. Column A is always a location number. If a user enters location 1 in column A, I need all information in that row to get copied over to it's own worksheet. Loc2 goes to worksheet named Loc2, if columnA contains loc5 it needs to go to worksheet for Loc5 and so on.

Any ideas? Thanks! Lori


Posted by Eric on August 30, 2001 8:11 AM

autofilters or vlookup, just ideas

You could use vlookup on seperate worksheets, but that's 50 worksheets plus the original- yikes
or you could autofilter your basic worksheet on the location number in column A
If either of these sound like what you want I can go into more detail.