tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I have a Sheet called "Reports 1"
and another called "Subs RR"
i want to copy coulmns from "Subs RR" to "Reports 1" but the sheets dont have the same data in the same columns so i need to pull it in one column at a time.
so heres what i'm looking for
Sheets "Reports 1" has headers in Row 20 so everything gets pasted below starting in row 21
"Subs RR" has headers in row 10 so we are coping from 11 to last row and pasting into Sheets "Reports 1" row 21 (and column?)
now in Sheets "Reports 1" Row 18 i have the Column letter that i want to copy from
so if A18 ="L" then i'm look to copy sheets "Subs RR" range ("L11 to L & lastrow") to Sheets "Reports 1" A21) and so on
the columns with headers in Sheets "Reports 1" are A to CZ and i need the macro to be able to do all of these,
hopes thats clear, please help if you can
Thanks
Tony
I have a Sheet called "Reports 1"
and another called "Subs RR"
i want to copy coulmns from "Subs RR" to "Reports 1" but the sheets dont have the same data in the same columns so i need to pull it in one column at a time.
so heres what i'm looking for
Sheets "Reports 1" has headers in Row 20 so everything gets pasted below starting in row 21
"Subs RR" has headers in row 10 so we are coping from 11 to last row and pasting into Sheets "Reports 1" row 21 (and column?)
now in Sheets "Reports 1" Row 18 i have the Column letter that i want to copy from
so if A18 ="L" then i'm look to copy sheets "Subs RR" range ("L11 to L & lastrow") to Sheets "Reports 1" A21) and so on
the columns with headers in Sheets "Reports 1" are A to CZ and i need the macro to be able to do all of these,
hopes thats clear, please help if you can
Thanks
Tony