djbsystems
New Member
- Joined
- Oct 7, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
- Web
Good Morning
Looking for some help and I hope I am posting to the correct area. I only use excel in a basic fashion, so what I may be asking may not be possible.
Every month I create a new excel spreadsheet to create a monthly summary report. I have a folder in Sharepoint with all the relevant spreadsheets for that month, what I have to do is open all these spreadsheets up then copy a column of data into the new spreadsheet, each spreadsheet data is pasted into a new column on the summary report. Then once all the info is imported I then do calculations based on the data.
What I am wondering is, is it possible to create a summary report template, then a button that basically imports all the data for me into the summary report. So excel will look up the amount of files in the folder on sharepoint, then import the data in each column until all the spreadsheet data has been processed.
Any help is appreciated.
Cheers
DJ
Looking for some help and I hope I am posting to the correct area. I only use excel in a basic fashion, so what I may be asking may not be possible.
Every month I create a new excel spreadsheet to create a monthly summary report. I have a folder in Sharepoint with all the relevant spreadsheets for that month, what I have to do is open all these spreadsheets up then copy a column of data into the new spreadsheet, each spreadsheet data is pasted into a new column on the summary report. Then once all the info is imported I then do calculations based on the data.
What I am wondering is, is it possible to create a summary report template, then a button that basically imports all the data for me into the summary report. So excel will look up the amount of files in the folder on sharepoint, then import the data in each column until all the spreadsheet data has been processed.
Any help is appreciated.
Cheers
DJ