Maybe you would be better served with just this formula in Reports sheet cell
A1 and copied down..........

=IF(LEN(data!A1)0,data!A1,"")

Vaya con Dios,
Chuck, CABGx3



"Eric" wrote:

Hello,
I have a workbook that has two worksheets, Data and Reports.
In both of them I have dynamic names setup to include all of the data needed
for the Reports worksheet. The Data worksheet connects to an external
datasource to get information and when there is new information it does
appear in the Data
sheet but not in my Reports sheet.

So Reports looks like this

A
bob
tom
sam

Because Data looks like this:
A
bob
tom
sam


But if I connect to the datasource to update everything and Data looks like
this:
A
bob
tom
sam
dick
jane

Reports will still look like this:
A
bob
tom
sam


How can I make it so that the new rows are added on Reports?


The dynamic name in Data is called "raw_names"
The dynamic name in Reports is called "new_names"
The A cells in Reports have this formula "=raw_names"


I am not too sure what this is called and have had trouble finding anything
similar to this issue.

Thank you for your time and help.
Have a nice day.