VBA Transfer columns from two reference sheets to a master sheet with different columns ranges.

[Simple_man916]

Hello:

Looking for code to transfer columns from two reference sheets to a master sheet with different columns ranges.

Two reference sheets "Tracker" & " Archive" have columns A:U first row headers
Master sheet columns A:Z

Need code to transfer columns A:E from reference sheets to B:F on Master sheet
Need to transfer columns F:U from reference sheets to K:Z on Master sheet

Unable to find similar code in threads


Can some one help?

Thank you

 

[Marc L]

Hi !

Welcome to this forum !

Some samples within this forum …
As you can already start you own code by activating Macro recorder !

And read the tip under just above the reply textbox !
​

 

[Luke M]

Future readers: Thread continued here:
http://chandoo.org/forum/threads/ne...sheets-to-master-with-different-ranges.31003/