I have a folder with xlsx files beeing added monthly - how to keep adding those into combi

[InvalidTxtString]

I have a folder that every month my vendor drops a xlsx file into containing a table named ProductsJuly and so on - I want another workbook, that automatically looks in this folder and "discovers" new files/tables, and adds the data, so I always have a combined table of all products - but I cant seem to figure out how to set it up, I can discover the folder via the DATA tab, but I just extract the workbooks info (placement, date etc)

[Richard Buttrey]

Hi,

Off hand I can think of two approaches.

1. Every month clear the data out the current combined table, then loop through every file in the folder and re-build the table by either opening each file and copying and pasting its data, or maybe using the Data Connection Functionality.

2. In the master workbook keep a list of every file name you've used, loop through the folder with the files, check whether the name of a file in there is also present in your list of previously used files and if not open the file and copy its data ti the next available row in your table, then add the file name to the list of file names.

I suppose there's a 3rd option and that's to get your vendor to drop a complete history file of all your products into the folder, with a consistent name and upload that file as your table.

[InvalidTxtString]

Thanks for the anwser Richard.

As of now, it looks like theres nothing I can do but just copy/paste new data into the master/table every month.

I was just hoping for some kind of auto-solution where the master table would discover that a new file/with table was in the folder, and it would automatically append all the new data to the Master Table...

[Richard Buttrey]

Of course I should have made clear that this would be done with a macro, not that you would need to manually undertake the task.

Try recording a macro to perform the task. Then you'll need to modify it to build in a loop to process the files in the folder and check for previously used files.
When you get to that stage post back with the macro you've captured.

[InvalidTxtString]

Again Richard, I thank you for your time to anwser, but you have way to high hopes for my skill-level ;-P