Deleting Duplicate Results when matching tables of data.

Hi Jordan

Thanks for getting in touch. There are two methods I can foresee to achieve this, based on the info you have provided.

The first is a VBA solution. As you have attended Access VBA you can probably get around Excel VBA, in which case sorting and filtering can get pretty processor-intensive in your code.

You should try direct cell manipulation, along these lines:

For ColumnCount = 2 To 10
'Destination row
Sheets("UK DATA").Cells(1, ColumnCount - 1).Value = _
Sheets("ALL CASES").Cells(9, ColumnCount).Value
' = Source row
Next intColumnCount

This assumes your data is 10 columns wide, and "exports" the data from one cell to another, in a relative fashion. This is about the fastest way you can transfer data across sheets. You would wrap this phrase in an IF statement to decide whether you were going to copy or not.

Secondly you can probably find really powerful and simple ways to do this with PivotTables. You can build the table as required, then drag the field that contains the region / area (e.g. "UK") into the Report section. Once you have done this you can go to the PivotTable menu, PivotTable Options then Show Pages. This will create a separate page for each region.

Consider these options and see what works best for you. Let me know if you need further guidance.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector