I have a spreadsheet (let's call it SS1) which pulls data via a formula from a different spreadsheet (let's call it SS2) that is issued on a fairly frequent basis and undergoes changes - sometimes rows are removed or reclassified, for example.
To ensure the data on my spreadsheet stays accurate, I want to run a macro that cross-checks the data on my spreadsheet with the sheet it is pulling it from.
What I want it to do is:
Take cells B1, C1, D1 and H1 (in SS1) - so all the same row, just different columns, and ensure it finds a corresponding 'match' in the spreadsheet it is pulling from (SS2). If it does, it leaves the data. If it doesn't, it removes the entire row.
The corresponding columns are as follows:
B (SS1) corresponds to U (SS2)
C (SS1) corresponds to C (SS2)
D (SS1) corresponds to E (SS2)
H (SS1) corresponds to T (SS2)
Is this possible? If so, how would I go about implementing this?
To ensure the data on my spreadsheet stays accurate, I want to run a macro that cross-checks the data on my spreadsheet with the sheet it is pulling it from.
What I want it to do is:
Take cells B1, C1, D1 and H1 (in SS1) - so all the same row, just different columns, and ensure it finds a corresponding 'match' in the spreadsheet it is pulling from (SS2). If it does, it leaves the data. If it doesn't, it removes the entire row.
The corresponding columns are as follows:
B (SS1) corresponds to U (SS2)
C (SS1) corresponds to C (SS2)
D (SS1) corresponds to E (SS2)
H (SS1) corresponds to T (SS2)
Is this possible? If so, how would I go about implementing this?
