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