I've looked for help on this before, but I approached it the wrong way. I need to copy and paste certain cells across workbooks in real-time.
WB1 (FABF Jobs.xlsm) contains information that is entered and changed constantly throughout the day. WB2 (FABF Live.xlsm) will be a read-only display that shows limited information from WB1. I already have WB2 set to update in real-time, so the macro will also need to auto update WB2 when changes are made to WB1.
WB2 needs to show projects that are marked "F" in column A, and only show Customer, Pcs, Lbs, and Ticket in that row. For example, when cell A3 is marked "F" in WB1, then copy B3:E3 and paste into B3:E3 on WB2. The days must coordinate, so other examples:
If A24 = "F" then copy B24:E24 and paste to WB2 G3:J3
If A108 = "F" then copy B108:E108 and paste to WB2 L24:O24
Anything in column A marked "D" or blank will not be copied to WB2.
Please help! I've been looking for a solution for weeks and I'm just exhausted... Thank you!
Bookmarks