Create dynamic sub-tables from a master list

[Arland]

Hi,

I am trying to create sub-tables on different sheets from a master list. The master list will be added to overtime and I do not want to have to go into the sub-tables and add the lines by hand. Is there a way to automate this by using a formula.

In the attached spreadsheet I have the master sheet containing Location names, on the next sheet I have a table that was generated from the master sheet location table. But when I add items to the master sheet table it should automatically update the 2nd spreadsheet. Could you please tell me what I am missing.

Thank you

 

[Somendra Misra]

Hi,

Can you check your file now.

Regards,

 

[Arland]

It does not seem to be updating the data sheet with new location entries.

 

[Somendra Misra]

After entering new details, go to last row of next table and press tab to bring new row in that table.

Regards,

 

[Arland]

Yes, this works, but do you know of a way to get them to display without doing this?

 

[Somendra Misra]

Other way is to convert the Data tab table to range and copy the formula to say 100 rows or as per your need. Now it will update till say 100 unique entries later you can copy the formula to further down.

See attached.

Regards,

 

[Arland]

Thats one way of doing it, but here is an example that does it automatically but I do not understand the formula.
So I cannot incorporate it into my spreadsheet.

 

[Somendra Misra]

If you see my second file, it will also do the same but with a smaller formula.

 

[Arland]

Perfect.... thank you so much for your help.

 

[Somendra Misra]

Welcome back anytime.