Transfer columns from comparable workbook if cell value exists

Hello,

I have a report fire every morning (1 workbook with 1 sheet) showing what active items need to be worked on (my team tasks are no color fill rows and all others team tasks are grey fill rows). Columns A and lets say J are blank for me to write status notes/dates in. Once I push it out of my department the row becomes grey, once it is done with all applicable departments the row goes away (based on column B "location" that is automatically updated each night). Currently I open both workbooks, look at column "D" or "description" to make sure it is the correct item and then manually copy/paste from old workbook to new workbook and save over old workbook. I also can't just copy paste the new sheet as the rows switch around. There is more information on the sheet such as current date so I do need to make sure to copy (or replace) from old to new. Is there a module code that I can paste in one workbook and run it every morning to save me about an hour a day. I still need to check all the lines so I don't need full automation but just a quick transfer.

If we call them old workbook, new workbook, and tasksheet and my location in column B is "mk", I am looking for a code that says something like "If a cell in column B contains "mk" in new workbook.taskheet copy cells in column A and J from old workbook to new workbook...and somehow put them on the correct row based on description column "D".

Any help would be a lifesaver!

https://www.mrexcel.com/board/thread...xists.1246055/

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.

Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)

Sorry about that...

Cross posts are here (possibly solved, not tested)
I am not authorized to post links but they are in VBA Express and MRExxcel