Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
250
Views
Topic starter
Dear Mynda,
How can we mirror a worksheet so that any changes made in one worksheet gets automatically updated in another?
Thank you,
Posted : 04/08/2017 7:44 am
Hi Arvind,
The only ways to 'automatically' update a cell/s is with formulas or a VBA routine that executes every time a cell is modified, I don't recommend either.
However, if you're happy to click a button (Refresh button) to update the other worksheet then I would use PivotTables to get an extract of your data on sheet1 and put it on sheet2 as described here:
https://www.myonlinetraininghub.com/excel-pivot-tables-to-extract-data
Mynda
Posted : 04/08/2017 9:07 pm
