Thank you for the information. Is there anyway to put together data in this manner with folders that have excel files with multiple sheets of the same data but for different projects? The sheets need to have different names, and the tables have to have different names within that excel file. So I am not sure if this is possible. Currently I am bringing them in all individually then merging, but this looks more automated.
Thank you for the information. Is there anyway to put together data in this manner with folders that have excel files with multiple sheets of the same data but for different projects? The sheets need to have different names, and the tables have to have different names within that excel file. So I am not sure if this is possible. Currently I am bringing them in all individually then merging, but this looks more automated.
It its the same data, then why is it in multiple sheets? 🤔
Same data structure but specific to different projects. Each tab is a different projects tracking data.
I am struggling. Only one sheet shows in the new table and not both sheets
Create the same name for a table or worksheet