I have data of diff regions: east, west, north & south
The data is in 4 diff sheets named: east, west, north & south.
The column heads are identical & formatting as well.
I want to consolidate the data from these 4 sheets into a fifth sheet of the workbook named:" Overall"
The "Overall" sheet should have the consolidated data in the sequence:
1. West
2. East
3. North
4. South
But all this should happen dynamically,
i.e. as & when i add a row of data to East sheet the consolidated data should automatically show added entry in a new row inserted below last row of east data.
Also the serial no. should adjust automatically sequentially
E.g.:
Sheet West:
1. CompanyA Rose 12cartons 6pcs
2. CompanyB Lotus 15cartons 9pcs
3. CompanyC Sunflower 18cartons 5pcs
Sheet East:
1. CompanyP Orange 72cartons 3pcs
2. CompanyQ Mango 55cartons 4pcs
3. CompanyR Apple 48cartons 1pcs
4. CompanyS Orange 89cartons 9pcs
Sheet North:
1. CompanyJ Shirt 20cartons 4pcs
2. Companyk trouser 95cartons 3pcs
Sheet South:
1. Company M Toy 56cartons 5pcs
Sheet consolidated:
1. CompanyA Rose 12cartons 6pcs
2. CompanyB Lotus 15cartons 9pcs
3. CompanyC Sunflower 18cartons 5pcs
4. CompanyP Orange 72cartons 3pcs
5. CompanyQ Mango 55cartons 4pcs
6. CompanyR Apple 48cartons 1pcs
7. CompanyS Orange 89cartons 9pcs
8. CompanyJ Shirt 20cartons 4pcs
9. Companyk trouser 95cartons 3pcs
10. Company M Toy 56cartons 5pcs
Observe that the serial no. is 1 to 10 & not 1,2,3,1,2,3,4,1,2,1
Kindly help.
The data is in 4 diff sheets named: east, west, north & south.
The column heads are identical & formatting as well.
I want to consolidate the data from these 4 sheets into a fifth sheet of the workbook named:" Overall"
The "Overall" sheet should have the consolidated data in the sequence:
1. West
2. East
3. North
4. South
But all this should happen dynamically,
i.e. as & when i add a row of data to East sheet the consolidated data should automatically show added entry in a new row inserted below last row of east data.
Also the serial no. should adjust automatically sequentially
E.g.:
Sheet West:
1. CompanyA Rose 12cartons 6pcs
2. CompanyB Lotus 15cartons 9pcs
3. CompanyC Sunflower 18cartons 5pcs
Sheet East:
1. CompanyP Orange 72cartons 3pcs
2. CompanyQ Mango 55cartons 4pcs
3. CompanyR Apple 48cartons 1pcs
4. CompanyS Orange 89cartons 9pcs
Sheet North:
1. CompanyJ Shirt 20cartons 4pcs
2. Companyk trouser 95cartons 3pcs
Sheet South:
1. Company M Toy 56cartons 5pcs
Sheet consolidated:
1. CompanyA Rose 12cartons 6pcs
2. CompanyB Lotus 15cartons 9pcs
3. CompanyC Sunflower 18cartons 5pcs
4. CompanyP Orange 72cartons 3pcs
5. CompanyQ Mango 55cartons 4pcs
6. CompanyR Apple 48cartons 1pcs
7. CompanyS Orange 89cartons 9pcs
8. CompanyJ Shirt 20cartons 4pcs
9. Companyk trouser 95cartons 3pcs
10. Company M Toy 56cartons 5pcs
Observe that the serial no. is 1 to 10 & not 1,2,3,1,2,3,4,1,2,1
Kindly help.