Hi,
I've been trying to find a solution but nothing works. I've a work book
Sheet 1 is labelled 'Total GVA'
Sheet 2 is labelled 'Single GVA'
Sheet 3 is labelled 'Total LDN'
Sheet 4 is labelled 'Single LDN'
Sheet 5 is labelled 'Spain'
Sheet 6 is labelled 'France'
Sheet 7 is labelled 'Portugal'
All sheets (1 - 4) contain security data.
What I'm looking for is a macro that will look, find and copy the entire row where Column H has following text "FRA"or"ESP"or"PTR" within sheets 1 - 4. The text is repeated multiple times and not in any order through each sheet. Then copied into their respective workbook
Where Col H = Fra copy this row into sheet labelled France, where Col H = Fra copy this row into sheet labelled Spain and the same for Portugal
Thanks for taking the time to read this
I've been trying to find a solution but nothing works. I've a work book
Sheet 1 is labelled 'Total GVA'
Sheet 2 is labelled 'Single GVA'
Sheet 3 is labelled 'Total LDN'
Sheet 4 is labelled 'Single LDN'
Sheet 5 is labelled 'Spain'
Sheet 6 is labelled 'France'
Sheet 7 is labelled 'Portugal'
All sheets (1 - 4) contain security data.
What I'm looking for is a macro that will look, find and copy the entire row where Column H has following text "FRA"or"ESP"or"PTR" within sheets 1 - 4. The text is repeated multiple times and not in any order through each sheet. Then copied into their respective workbook
Where Col H = Fra copy this row into sheet labelled France, where Col H = Fra copy this row into sheet labelled Spain and the same for Portugal
Thanks for taking the time to read this
