Updating tables from a master table

cradd64

New Member
Joined
Oct 5, 2024
Messages
7
Office Version
  1. 2016
Platform
  1. Windows
I'm sure this is something easy but I just can't work out how to do it and its puzzled me for a long time.

I have a master table this is created from an export into an excel workbook. This is from a database and has a large number of columns and rows.

From this master table I have a number of other tables which reference the master table. So sub table 1 would ref cell A2, B2, C2 (using the = formula) to create a new table. I can then drag this down to ensure it covers all the rows in the master table. So say that there are 500 rows in the master table I could drag down on sub table 1 to cover A1:C500.

The master table will change number of rows on each import, so it may shrink to 400 but most likely grow to 600 and continue growing. What I would like to do is ensure that the various subtables shrink or grow with the row changes in the master sheet.

I could just fill down the sub sheets for 10000 rows but this doesn't seem very efficient.

I'm sure there must be an easy way to link them together but I'm unable to find this.

Any help would be gratefully received.
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
Hello,
Did you take a look at PowerQuery ? You'd just need to refresh the query to be up-to-date.
 
Upvote 0
Solution
Hello,
Did you take a look at PowerQuery ? You'd just need to refresh the query to be up-to-date.
thank you for your answer to be honest no I didn't I've not really explored power query - but I think ill have a look at a few YouTube videos. thanks
 
Upvote 0

Forum statistics

Threads
1,226,478
Messages
6,191,237
Members
453,649
Latest member
jtc19

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top