FROGGER24
Well-known Member
- Joined
- May 22, 2004
- Messages
- 704
- Office Version
- 2013
- 2010
- Platform
- Windows
I have a master file called BTRF AIIV.xls with worksheet called BTRF Listing in columns 1-18 starting in row 4 I would like to copy data from multiple workbooks with various variable length row. Starting in row 2 would like to copy from worksheet invhis to BTRF Listing. this code will be used by multiple users so I think all the workbooks will be open to run the code on
From columns to columns
The "from" columns start in row 2 and last row will be defined by column A
the "To" columns will start in row 4
20 to 1, 10 to 2, 22 to 6, 21 to 7, 28 to 9, 27 to 10, 32 to 12, 21 to 14, 23 to 15, and 1 to 18
Thanks for any assistance provided
From columns to columns
The "from" columns start in row 2 and last row will be defined by column A
the "To" columns will start in row 4
20 to 1, 10 to 2, 22 to 6, 21 to 7, 28 to 9, 27 to 10, 32 to 12, 21 to 14, 23 to 15, and 1 to 18
Thanks for any assistance provided