Hi,
I have a working iterative macro using local excel files as my input, and when ever I use my macro I have to select/use a local file. Now I want to do the change in to using a created table during my workflow, that way my workflow will not use any local files.
Can we use a table or summarize tool for this? I understand the input will read the file/sheet name
The image below is my created macro:
The image below is how I would like to use my macro in a workflow:
Thanks