smrmodel78
New Member
- Joined
- May 2, 2022
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
I have minimum VBA experience, but I a file that has multiple columns that need to be copied to another workbook. The issue i'm having is 1/i don't know how to copy multiple ranges of cells from one workbook to the other and 2/how do i get that specific column data to post into a specific sheet?
In the image, for example, i need to copy all data from wb1.sheet1.ranges C12:C26 & C32:C38 much more, and copy it to wb2.sheet (sheet is based off name in row 4) Range A12:A26 & A32:A38. Each column in wb1 will go to a different worksheet.
Unfortunately I can't attach the file because of PHI. But any help to start would be awesome.
In the image, for example, i need to copy all data from wb1.sheet1.ranges C12:C26 & C32:C38 much more, and copy it to wb2.sheet (sheet is based off name in row 4) Range A12:A26 & A32:A38. Each column in wb1 will go to a different worksheet.
Unfortunately I can't attach the file because of PHI. But any help to start would be awesome.