Copying data from one sheet to another if criteria is met.

[Ezza]

Hi I am trying to copy data from sheet1 to various other sheets if certain criteria is meet.
In my case

Copy all rows (A-M) where column G = Gisborne/ Wairoa


Any help would be greatly appreciated

I have several sheets I need to do this for as I am breaking the data down into separate locations
the data in sheet1 is exported from another workbook (not sure if that makes any difference)

[JLGWhiz]

Hi Ezza, welcome to the forum.
You forgot to tell us which sheets the data will go to and where on the destination sheets you want the data entered. Try to include your complete details in the original post to avoid a lot of Q&A posts.

[Ezza]

HI! thanks you and sorry, here's a little more detail
I need separate sheets for each separate region (total of 7 regions) and I have the 'DATA' sheet which is the data extracted from another workbook.
if column G in 'DATA' = "Wellington" then copy the entire row into the 'Wellington' Sheet

My region list is
Taranaki
Wellington
Bay Of Plenty
Auckland
Manawatu
Gisborne
Wairarapa

Does that help so I have 7 sheets named after each region and the DATA sheet has the information from columns A-M that I want to copy over, if the region matches column G into the matching worksheet

[JLGWhiz]

Please Login or Register  to view this content.

Install this in code module1. You can run it from the Excel window with Alt + F8, then use the dialog box for macros.