Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to auto insert rows in a list of numbers | Excel Discussion (Misc queries) | |||
how do I create a macro to auto insert rows? | Excel Worksheet Functions | |||
how to auto insert rows in Excel | Excel Discussion (Misc queries) | |||
Auto Insert Rows of Data?? | Excel Discussion (Misc queries) | |||
Auto Insert of Rows | Excel Worksheet Functions |