I would like to know if there is a way in VBA to copy all rows based on the Name (Column B) and paste it into a sheet in another folder.
Would like to set this up to run monthly. The complete sheet has more columns and rows for all the months in the year.
I would like a macro that I can connect to a button to run this.
Please advise if this is not possible.
Thank you for the help.
Would like to set this up to run monthly. The complete sheet has more columns and rows for all the months in the year.
I would like a macro that I can connect to a button to run this.
Please advise if this is not possible.
Thank you for the help.