Excel online automation question!
I have a workbook on Sharepoint that has 11 sheets of account manager data - one sheet/account manager. All have the same heading (A9:AF9) but do not have the same number of accounts.
What I am needing to do is pull all data from each account manager's worksheet and bring it to an all accounts "Master" worksheet. Column A cells would be populated for any rows needing to be moved over. I need it to be dynamic and/or automate frequently as the managers update their accounts daily.
The top 7 rows of the Master document has summary data, so I will have the heading for it to be A9 as well.
I also have 2 sheets in the workbook that I do not want to include in the loop, if possible.
Hoping that someone is able to assist with a script for my automate tab.
I hope I gave all relevant data, but please let me know if I missed something! I truly appreciate it and happy holidays!
I have a workbook on Sharepoint that has 11 sheets of account manager data - one sheet/account manager. All have the same heading (A9:AF9) but do not have the same number of accounts.
What I am needing to do is pull all data from each account manager's worksheet and bring it to an all accounts "Master" worksheet. Column A cells would be populated for any rows needing to be moved over. I need it to be dynamic and/or automate frequently as the managers update their accounts daily.
The top 7 rows of the Master document has summary data, so I will have the heading for it to be A9 as well.
I also have 2 sheets in the workbook that I do not want to include in the loop, if possible.
Hoping that someone is able to assist with a script for my automate tab.
I hope I gave all relevant data, but please let me know if I missed something! I truly appreciate it and happy holidays!
