Copy cell ranges from multiple worksheets to one worksheet?

[mrbusto71]

Hey there! After much scrounging I was able to get a Macro on button click to copy a cell range from one workbook to another.

It works great! Here's the code I'm currently using that works like a champ:

Please Login or Register  to view this content.

This works great if I only want to copy from one source document. In this instance, I'd like to copy from multiple docs though, all in the same directory. So, for example, I'd like to copy cell range A3:H15 from WPD Doc TEST to A2:H14 on Reporting Doc TEST (what the above SUB is doing currently), but then copy the same cell range from a different WPS book (so like, WPS Doc TEST2) to a new range in the same destination workbook (Reporting Doc TEST). I'd like to be able to do this as many times as needed, but I need to figure out how to just get a 2nd one working first, then I can figure out the rest.

Any help would be stellar. Thanks!

[stnkynts]

Just follow your working template but add a new variable in for the new workbook and specify the new range

Example:

Please Login or Register  to view this content.

[mrbusto71]

Awesome! Yeah, I couldn't figure out if I needed to Set x multiple times as the same variable or differentiate them somehow. That's super easy then, thanks! +Rep for you, sir/madam.

[stnkynts]

Thanks for the rep. Technically you could use the same variable over and over provided you "Set" it to something different each time. I like to give it a number though so that it is easier to distinguish if you ever need to modify the code.

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.