Hi Everyone,
I am a self taught excel user. I need your help to solve the following problem.
I have around 50 individual sheets, each with a designated table area (the top left corner cell is same for each worksheet) for cheque details
I want a consolidated "master cheque details" that should get automatically updated sequentially as and when a new entry in any of the worksheet is made.
The bottom row in "master cheque details" has totalling and other figures that should dynamically allow a new entry to remain as the last row entry
Please help
Bookmarks