Hello,
I am new to Macros and would greatly appreciate it if someone had VBA coding help. I am trying to build a Macro that pulls filtered data on the department/class level from a weekly excel file to a set location (column/row) in a new excel file. Instead of having to constantly filter from the weekly file and then copy/pasting into the new excel file location, would a Macro be possible?
Thank you
I am new to Macros and would greatly appreciate it if someone had VBA coding help. I am trying to build a Macro that pulls filtered data on the department/class level from a weekly excel file to a set location (column/row) in a new excel file. Instead of having to constantly filter from the weekly file and then copy/pasting into the new excel file location, would a Macro be possible?
Thank you