Question: If I highlight a table and press the delete key it appears to go away. I'm sure the data is gone, but what about the table itself? The question is prompted by the behavior of named ranges. When you delete them the range is still defined and it still appears in the navigation box even if there is no data in the cells.
The back story is that every day we import about five hundred lines of data. The import macro simply highlight yesterday's data and pressed the delete key. Then it opens the export data file and copy/paste the daily data dump.
From these two columns I would like to create a dependent dropdown in two places from distinct information. I’ve been reading up and understand the process. But I have found three different methods to make it happen. Two of the three say you can do it with named ranges but they recommend you do it with tables. I know that when the macro pastes the data in the same place the named ranges will be populated again. I was just wondering if the tables feature behaved in a similar manner.
Thanks. And, may this time of the year be great for you. I’m a Merry Christmas guy myself. But I understand that Christmas isn’t the only special holiday around this time of the month. However you view it I hope that what you see is what you wish for to see.
Bookmarks