lee2121
New member
- Joined
- Sep 10, 2018
- Messages
- 11
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office 365
Hi i have two sheets within an excel file, Sheet 2 contains the data i wish to move to Sheet 1.
Sheet 2 the columns can have from 1 to 48 and the rows can go down to about 5000 rows, code will always be in column A starting in row 2.
Sheet 1 the columns appear at reference K22 to AY22 and the coumn numbers in sheet two need to enter the data into the correct coulmns in Sheet 1, the code appears in row BK25 to BK4284 this will match a code in Sheet2 where applicable.
How can i use VBA to move te data from Sheet 2 to Sheet 1 and put it into the correct columns?
Thank you for looking.
Sheet 2 the columns can have from 1 to 48 and the rows can go down to about 5000 rows, code will always be in column A starting in row 2.
Sheet 1 the columns appear at reference K22 to AY22 and the coumn numbers in sheet two need to enter the data into the correct coulmns in Sheet 1, the code appears in row BK25 to BK4284 this will match a code in Sheet2 where applicable.
How can i use VBA to move te data from Sheet 2 to Sheet 1 and put it into the correct columns?
Thank you for looking.