Hi, I have several sheets one for each city and I know the last filled cell of each sheet every month. I want to make an all-India sheet consolidating the data in different sheets every month. How best can I do it? City Last filled row number Mumbai 616 Delhi 630 Kolkata 583 Chennai 322 Hyderabad 362 Bangalore 371 Punjab 496 The last filled row number changes every month, but I get the above table every month.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Combining worksheets based on last filled cell

Thread starter ankitgoel888
Start date Jan 8, 2015
Tags

combining worksheets

ankitgoel888

New Member

Jan 8, 2015

Hi,

I have several sheets one for each city and I know the last filled cell of each sheet every month.
I want to make an all-India sheet consolidating the data in different sheets every month. How best can I do it?

[TABLE="width: 203"]
<tbody>[TR]
[TD]City[/TD]
[TD] Last filled row number[/TD]
[/TR]
[TR]
[TD]Mumbai[/TD]
[TD="align: right"]616[/TD]
[/TR]
[TR]
[TD]Delhi[/TD]
[TD="align: right"]630[/TD]
[/TR]
[TR]
[TD]Kolkata[/TD]
[TD="align: right"]583[/TD]
[/TR]
[TR]
[TD]Chennai[/TD]
[TD="align: right"]322[/TD]
[/TR]
[TR]
[TD]Hyderabad[/TD]
[TD="align: right"]362[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD="align: right"]371[/TD]
[/TR]
[TR]
[TD]Punjab[/TD]
[TD="align: right"]496[/TD]
[/TR]
</tbody>[/TABLE]

The last filled row number changes every month, but I get the above table every month.