You’re offline. This is a read only version of the page.
Announcements
Hi there,
I'm currently trying to build a workflow that allows me to automatically create a report from individual Excel reports stored on our SharePoint.
All of our Excel reports have the same format and a sheet called "Summary". What I want to do is collect every Excel report in a specific folder on SharePoint, find the "Summary" sheet and copy that "Summary" sheet to the new workbook and then rename them to match the name of the report it came from. Ideally the "Summary" sheets that are copied would maintain their formatting, and the data we need is not in an easy location (cells D5:K22).
I've attached what I've done so far (excluded from the screenshot is only the manual trigger I've set up). Where do I go from here?
Is it possible to extract a specific named sheet from each excel file, rename it and copy that to another workbook?
If so, how do I continue this? Will I lose formatting?
If not, do I need to try another tool?
Share
Report
All responses (
Answers (
538
