You’re offline. This is a read only version of the page.
Announcements
*I know very little about Excel Scripts or Power Automate*
I am trying to record a script that can be used on different excel sheets to basically reformat certain excel downloads.
The excel sheets that I am downloading are all in the same format.
The problem that I am running into, is in order to separate two groups of information on the newly downloaded sheet I have to create a filter to separate these things. The things that I am trying to separate will always just be 2 names, along with some information that is attached to those names.
The script runs smoothly, aside from the fact that when the script runs, it is trying to find the names from the filter that was recorded on the original sheet, therefore producing incorrect information.
I guess I'm just asking if anyone knows a solution to my problem.
Attached: The raw file that is downloaded, the file of the same information that is reformatted to how I would like it, and a file containing the recorded script showing how I completed the reformatting, along with the errors (line 24 & line 30)
Share
Report
All responses (
Answers (
522
