Here I am again today with another version of the question I got answered yesterday.
Context:
I have a bill of materials (BOM) structure which is split into excel tables such as electronics, mechanical, accessories etc.
Every table is in a different folder on sharepoint to be filled by a different person. Tables have the same exact columns.
Can you show me how I can create a full BOM by appending above tables and making a new excel workbook, then save that workbook on a sharepoint folder then name it as File_ddmmyy once a week?
Thank you in advance!
