Frederik Grund
New Member
Hi Chandoo.
I would like to copy data from Excel Workbook1 to Excel Workbook2 automatically. However, Workbook1 contains output data from another program which varies from day to day. This means that I need a code that transfers and transposes data matching column/row names (column "xx" in workbook1 to row "xx" in workbook2) rather than matching column A1 to row 1.
I have uploaded two Workbooks which illustrates the problem:
- Day1(sheet1 example) I have output for all my parameters (A-Q) and want to transfer data from Workbook1 B2-B18 (parameter A-Q) till Workbook2 B2-R2 (parameter A-Q).
- Day2 (sheet2 example) I only have output for parameter F-Q and thus want to transfer data from Workbook1 B2-B13 (parameter F-Q) till Workbook2 B2-R2 leaving cells blank when parameters don't match F-Q.
- Day3 (sheet3 example) I only have output for parameter G and Q and want to transfer data from Workbook1 B2-B3 till Workbook2 B2-R2 leaving cells blank when parameters don't match G and Q.
Can this be done?
Best regards,
Frederik
I would like to copy data from Excel Workbook1 to Excel Workbook2 automatically. However, Workbook1 contains output data from another program which varies from day to day. This means that I need a code that transfers and transposes data matching column/row names (column "xx" in workbook1 to row "xx" in workbook2) rather than matching column A1 to row 1.
I have uploaded two Workbooks which illustrates the problem:
- Day1(sheet1 example) I have output for all my parameters (A-Q) and want to transfer data from Workbook1 B2-B18 (parameter A-Q) till Workbook2 B2-R2 (parameter A-Q).
- Day2 (sheet2 example) I only have output for parameter F-Q and thus want to transfer data from Workbook1 B2-B13 (parameter F-Q) till Workbook2 B2-R2 leaving cells blank when parameters don't match F-Q.
- Day3 (sheet3 example) I only have output for parameter G and Q and want to transfer data from Workbook1 B2-B3 till Workbook2 B2-R2 leaving cells blank when parameters don't match G and Q.
Can this be done?
Best regards,
Frederik