Hi All,
I'm a complete beginner and need some help with using macros to merge multiple sheets with different schemas. I have read other forums and tried to follow step by step guides but I keep running into the same problem.
I was given the following workflow and macro to use in the "ReadSheets.yxzp" file for a sample Excel file. Please also refer to the "Output File.xlsx" I was trying to achieve.
However, I am now trying to apply this workflow and macro for a different file. I have tried to change the file on the "Reader.yxmc" macro and used the first sheet as a sample (just like the original macro for the "Amy Green" sheet):
When I run this on the "ReadSheets.yxmd" workflow, it doesn't pull all the data from the different Excel sheets and only repeats from the first Excel sheet in the macro file:
I run into the same problem when I try to apply this to any sample macro and I'm not sure what the issue is.
I'm also not sure how to add a blank preparation tool to connect a macro when I create a new workflow (I need to do this for different Excel files and merge the sheets together on a monthly basis). Does this mean I need to create a new macro for every new workflow and copy+paste the tools from the previous workflow?
