Auto Insert New Rows
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. |
Auto Insert New Rows
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. |
All times are GMT +1. The time now is 11:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com