Hello there,
I've this question:
i have an automation that when a mail is received save the xls attacched in a onedrive folder.
This file is composed by 3 worksheet ("Cover", "Sheet2", "Sheet3") and i need every time a new file is saved the content of this file is copied in a Master file that have the same colum of the saved file:
Master file.SheetMaster.xlsx
Data1 | Data2 | Data3|
Apple 123 456
Samsung 122 122
Saved file. 20240613.xls
Sheet2
Blank row
Blank row
Data1 | Data2 | Data3|
Xiao 124 345
Master file.SheetMaster.xlsx
Data1 | Data2 | Data3|
Apple 123 456
Samsung 122 122
Xiao 124 345
the objective is, for each file (only sheet2) that will be saved in the folder, to delete the first 2 blank row and append this sheet data in the master file sheet as above.
How can i make this automation?

Report
All responses (
Answers (