filtering list into workbooks

[valeix]

Hi All,


I have a question which is probably simple for many of you Excel experts.

I have a report that is run weekly - it's an export from a database - every week different number of rows.
What I need to do is filter the list based on the column 1 and copy the whole row into one of the workbooks depending on the context of the cell in the column 1 - ie New York goes onto the New York workbook, London goes onto London etc.

a little VB would do the trick, as I don't want to use IF statements here.

I'm sure you can solve this.


Thanks,
Valeix

[raypayette]

It seems to me all you need to do is to use the Filter (Data, Folter, select London...) then copy the data!

[valeix]

It seems to me all you need to do is to use the Filter (Data, Folter, select London...) then copy the data!

Well that's what i usually do. Thing is I have something like 30 locations and it's just a waste of time to do same thing manually every week.

Thanks anyways.

[raypayette]

Then use the macro recorder with a shortcut key to automate this proxcess!

[valeix]

Then use the macro recorder with a shortcut key to automate this proxcess!

Since it's a different number of cases every week recorded macro will not work simply because it records the row number when you copy. And the number of rows for each location is different every week.

Thanks,
Valeix

[peejay]

if the list of 30 locations is constant, then recording / running a macro to filter on each location, then copy and paste the filtered cells should work