I am trying to get data from one file and put into another.
The source has a macro that every time I hit a button it updates a
range of data from a tab labeled "Results" with the source range of
A36..C100.
I need to update this data 16 times but want to be able to copy and
paste it into a different file so I have 16 sets of data all on one
page.
The source file is macro password protected so I can not modify this
file.
How can I do this?
Thanks in advance