lovingexcelbutconfused
New Member
- Joined
- Jan 25, 2005
- Messages
- 5
Hi all;
I have 5 different sheets with different columns; There are only two columns which they have in common; NbrID and user date. Some have more rows than others.
We have a formula that is based on each of these sheets having the rows in the exact same order. If one sheet does not have the Nbr ID, i want excel to insert rows with the missing number ID only. At the end of the day, assuming the spreadsheet with the most rows has 5000 rows, all the spreadsheets should have 5000 rows.
Short of having to go through each sheet on comparing one line at a time, is there an other way?
I have 5 different sheets with different columns; There are only two columns which they have in common; NbrID and user date. Some have more rows than others.
We have a formula that is based on each of these sheets having the rows in the exact same order. If one sheet does not have the Nbr ID, i want excel to insert rows with the missing number ID only. At the end of the day, assuming the spreadsheet with the most rows has 5000 rows, all the spreadsheets should have 5000 rows.
Short of having to go through each sheet on comparing one line at a time, is there an other way?