Macro: Copy from one workbook worksheet to a different workbook worksheet

[Virgil Beach]

Hello,

First a little explanation as to what kind of workbook I have. There are 100 tabs in my QC/QA workbook and 50 tabs in my previous month workbook. I am comparing Current Month data to Previous Month data for several metrics.

The previous month data is pulled from a seperate workbook.

I want to set up a marco that will allow me to copy "B4" data from the previous month workbook and paste it into cell 'B49' of my QC workbook.

I just want to be able to run the macro by hitting "CTRL" + "q" from my QC worksheet I have selected and then grab the data from the other previous month workbook.

***The naming convention of the macro I have built causes the copy and paste function (macro) to grab the same data from when I first built the marco. It will paste correctly, but it paste from the same worksheet instead of the one I have selected.***

Any help is appreciated.

[Virgil Beach]

I thought I was able to maybe USE RELATIVE REFERENCES, but that didn't work.

[Virgil Beach]

Here is the code I tried:

Please Login or Register  to view this content.

I have to protect names so just used "????? "

My attempt was to use key strokes to locate cell B4 copy and paste back at cell B49.