Duplicate a Table and Automatically have it Update as Original Table Updates?
I have two worksheets. The first worksheet has a large table in it. I would like to duplicate three columns from this table in the second worksheet and have it automatically add new rows as the table in the first worksheet has new rows added.
Any help on this matter is appreciated!
By far the easiest way, since you have Office 365, is to use Power Query (Get & Transform).
If you need a demo, then please attach a sample desensitised workbook and I'll talk you through it.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Unfortunately I can't install Power Query as I am running this on a business machine.
Last edited by AliGW; 08-15-2018 at 09:38 AM.
You don't have to - it comes for free with Office 365.
or are you saying that you don't have 365 on your business machine? If so, then please update your user profile (se how I've done mine to distinguish the versions I use).
Ah, I'm using Office 2013, my mistake. Is there any other way solve my problem?
Last edited by AliGW; 08-15-2018 at 09:52 AM.
Yes, there may be several ways.
Is all you are wanting a mirror of those three columns?
Indeed, and for the second table to automatically add new rows as the first table has new rows added.
So explain why you need these three columns on a separate sheet. Will they need to be sorted? How will users need to interact with them other than looking at them?
The first table compiles data from a server database, the second table picks out the name, date received and date completed columns. These values are used to create some metrics and display visually on a separate sheet. They are separate sheets to keep the metrics a standalone feature.
Can you please answer the second crucial half of my query?
The data is sorted in date order; newest at the bottom. The user doesn't need to interact with the data, just oversee it and plot graphs from it.
All you really need, then, are three formulae copied down as far as you need just tweak the cell references to the first cells in each column):
=IF(Sheet1!D1="","",Sheet1!D1)
=IF(Sheet1!E1="","",Sheet1!E1)
=IF(Sheet1!F1="","",Sheet1!F1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks