I would appreciate some ones help to correct a macro I'm trying to write. The macro copies 3 columns from Sheet1 to Sheet2 in a selected location. The 3rd column copied needs to be pasted in a different column in Sheet2.
Sheets("Sheet1").Select
Range("A2:A10, G2:G10, H2:H10").Select
Selection.Copy
Sheets("Sheet2").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Above copies Columns A, B & H (ranges) from Sheet1 and pastes to A, B & C columns in Sheet2 or depending on what cell was selected in Sheet 2 (1st, 2nd & 3rd columns). The requirement is to to have H pasted to Sheet2 F (6th column).
I have tried several Target.Offset statements but have had no success. I've attached my sample sheet with what I have so far.
Thanks in advance
Bookmarks