geomano
06-02-2017, 04:24 AM
Hi, I am struggling with one idea connected with a VBA macro for matching and updating data across 4 different spreadsheets.
The main concept is that I have one master file with specific values in column A. Those values correspond to tabs names in 3 remaining files.
I would like a VBA macro to:
1.Match the values from Master's column A to tabs names in 3 files.
2.Once the proper tab is selected, I would like the VBA code to copy specific cells from Master tab to the other one.
Seems a little bit challenging, but I will greatly appreciate some help.
The main concept is that I have one master file with specific values in column A. Those values correspond to tabs names in 3 remaining files.
I would like a VBA macro to:
1.Match the values from Master's column A to tabs names in 3 files.
2.Once the proper tab is selected, I would like the VBA code to copy specific cells from Master tab to the other one.
Seems a little bit challenging, but I will greatly appreciate some help.