Copying rows based on criteria

[suedavies]

Hi
I want to use VBA code to auto populate sheets with the data from my mastersheet based on the criteria shown in column A, I've managed to get most of it working but we need to retain the data on the master sheet and at the moment I am duplicating the entries on the second sheets.

i have attached a dummy example of what I am trying to do

Many thanks

Sue

[Marc L]

Hi !

You can use the easy advanced filter method to directly filter and copy data …

[suedavies]

thank you but we want to be able to automate the process and not have to do filters and then copy paste - I presume this is what you mean to do

thanks

Sue

[suedavies]

Hi Marc L I'm trying the advanced filter but it's testing my brain

[mike7952]

Is this what your wanting?

Please Login or Register  to view this content.

[mike7952]

Is this what your wanting?

Please Login or Register  to view this content.

[suedavies]

Mike7952 - thankyou - you are amazing

[suedavies]

Sorry Mike7952 I have one more query, see attached sheet - If I want to add more columns for example for addresses how do I change the code to copy over the complete row, I envisage adding more data to the mastersheet

Many thanks

Sue

[mike7952]

This will work, see highlighted changes

Please Login or Register  to view this content.

[suedavies]

Thank you Mike7952 that is amazing