Hello All

This is my 1st post so am hoping someone can help me. I have a master workbook whereby I want to paste data ranges of 2 columns by approx 300. There are approx 50 of these ranges which are 3 columns apart. So basically I need some code/macro which selects the range and then offsets 3 columns to select the next range.

I have recorded the macro so that all the work books are open with the intention to close each one as when it is updated from the master workbook.
I know that I could identify all the ranges and record the movements for each range but was hoping to record/write some code which offset each range and copied in using paste values.

Hope this makes sense and any help will be much appreciated.

James