Copy data from one WB to another

[Closed]
Report
Posts
2
Registration date
Wednesday April 3, 2013
Status
Member
Last seen
April 6, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello. I'm hoping I can describe my problem/question in a way that makes sense... Here goes:

At my work, we have a program that will create an excel workbook of our current open orders titled "backlog MM-DD-YY" (the date being the date the program is run). This workbook has columns titled Customer Name, Sales Order Number, Part Number, Due Date, etc., Comments.

I'm looking for a formula/macro to copy the text in the Comments column from the previous backlog report to the current one, keeping in mind that the report changed based on the shipment of orders and the receiving of new ones.

Any and all help would be greatly appreciated. Please let me know if you have any further questions, or need more info.

Thanks!!!

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
I am understanding it correctly

1. On day 1, you get a report with some comments

2. On day 2, you get a new report with some newer data. Howerver that new book also has information about items from day 1, but comments are now updated.

3. You want sort of running "comments" log

It might be easier to answer you by looking at some sample book. But on surface it looks like you would need a macro.
1. check in newer item was in previous workbook
2. if found, copy the comments and paste in new book
3. if not found, no action

Depending on rows, you can also look into using some formula (may be VLOOKUP)
Posts
2
Registration date
Wednesday April 3, 2013
Status
Member
Last seen
April 6, 2013

That's exactly what I'm looking to do! Just can't figure out the coding...
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
First thing that is a must, is some way to uniquely identify the items in two workbook to match up items in the two work books. Since it is a system generated workbooks, I am presuming that's not an issue. Other issue is that next day, previous day's workbook must be available. I am guessing, no issues in that too.

You can use vlookup for matching.
Do this
1. Open excel.
2. Start macro recorder
3. Open day 1 workbook
4. Open day 2 workbook
5. In day 2 workbook, pull a sample comment from day 1 workbook using "VLOOKUP" or something that would work for you
6. Stop the macro
7. Paste the resulting macro back here