sorting data into specified worksheets...

[nathanstevens]

Hi,

I am trying to assign a macro in excel that inserts a row of data into a specified worksheet based on the region column. So basically, I have a report of data from many regions that I would like to filter out into their appropriate worksheets based on the record region. I haven't had much to do with excel macros before, only java, so I am not sure of the syntax however here is what I want to do in psuedo code to give you a better idea of what I want to achieve...

if (column(region) = "region1") then
paste this row into the "region1" worksheet
if (column(region) = "region2") then
paste this row into the "region2" worksheet...and so on.

Any help in this matter would be greatly appreciated. The macro will be assigned to a button named "Distribute Data" that will be seen from the worksheet with all the raw data on it.

Thanks in advance.

 

[kieran]

I quick workaround I use in this case is to create a pivot table.
Group the data by region.

Tehn double click the entry for a region. A new worksheet will automagically be created showing the data for that entry only.

It is a nice drill down feature that pivot tables have, but is also a good way to consoldiate and sort data in this sort of instance as no macro is necessary.