I was wondering if there was a way to create a table and populate it with certain data. Once the data has been populated, have the table be able to add rows if more data is added to the sheet.
I've added an example spreadsheet to the thread. The idea in the spreadsheet is that there are multiple "Data Sets." I've given them just some dummy headers and values. There are also different sets that will be read against the "Data Sets."
What I would like to see, if possible, is a macro that could populate the data in the way that it is set up now, and also be able to add rows if more "Data Sets" or different Sets are added to the sheet.
Bookmarks