ankitgoel888
New Member
- Joined
- Nov 24, 2014
- Messages
- 5
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?
<tbody>
</tbody>
The last filled row number changes every month, but I get the above table every month.
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 |
<tbody>
</tbody>
The last filled row number changes every month, but I get the above table every month.