Associate
- Joined
- 26 Jun 2005
- Posts
- 1,487
I'm working on some new spreadsheets and I'm encountering some intermittent inconsistencies.
Workbook A and Workbook B have some customer data on them, unfortunately they are created independently. I'm Copying and Pasting them into a new Workbook C into Sheet1 and Sheet2 respectively. The Sheets have (amongst others) Columns for Customer Name and a Reference Number. They should be exactly the same, so Mr Smith is 12345 and is in Row 5 say.
I'm creating a new Column on Sheet2 which is an IF formula but the output isn't as expected for all the rows. It starts out OK but then some Rows in Sheet1 aren't in the right place, they are 3-4 rows up or down of where they should be.
Is there a way to check that : Sheet1 Row 5 is (Mr Smith and Agreement 12345) the same on Sheet2 and show me where the errors are?
The Sheets are about 600 rows long and increasing each week.
Thanks.
Workbook A and Workbook B have some customer data on them, unfortunately they are created independently. I'm Copying and Pasting them into a new Workbook C into Sheet1 and Sheet2 respectively. The Sheets have (amongst others) Columns for Customer Name and a Reference Number. They should be exactly the same, so Mr Smith is 12345 and is in Row 5 say.
I'm creating a new Column on Sheet2 which is an IF formula but the output isn't as expected for all the rows. It starts out OK but then some Rows in Sheet1 aren't in the right place, they are 3-4 rows up or down of where they should be.
Is there a way to check that : Sheet1 Row 5 is (Mr Smith and Agreement 12345) the same on Sheet2 and show me where the errors are?
The Sheets are about 600 rows long and increasing each week.
Thanks.