Chunk
12-01-2022, 11:03 AM
Good afternoon,
I have two workbooks I am trying to transfer data between
workbook1 is the source file
workbook2 is the destination file
The source file that I receive usually comes to me with more columns of data than I need, and columns are never in the same order.
All of the columns in the source and destination files have a title
What I would like to be able to do is search for the desired header, copy the data for the latest date (11/25/22), then paste it into workbook2 in the appropriate spot
Attached are examples of workbook1 and workbook2. Sample numbers are inserted to show where data starts and where I would like it to go.
Please let me know if I need to better explain anything.
Any help you can give is greatly appreciated.
Chunk
I have two workbooks I am trying to transfer data between
workbook1 is the source file
workbook2 is the destination file
The source file that I receive usually comes to me with more columns of data than I need, and columns are never in the same order.
All of the columns in the source and destination files have a title
What I would like to be able to do is search for the desired header, copy the data for the latest date (11/25/22), then paste it into workbook2 in the appropriate spot
Attached are examples of workbook1 and workbook2. Sample numbers are inserted to show where data starts and where I would like it to go.
Please let me know if I need to better explain anything.
Any help you can give is greatly appreciated.
Chunk