MCRO CPY graphics.xlsxMCRO CPY Plates.xlsx


The data in these workbooks are fictional. All data entered has been for the sole purpose of a sample worksheet.
-


Okay so it looks really complicated at first so I will walk you through it.
If you look at the docket # in column I, you will see that several rows have the same docket #. In those rows, you’ll see in column J that there are different products for that same docket #. ART SEPS PLATE and MYL.
Don’t worry about the MYL
We are only concerned with the ART, SEPS, and PLATES.

This would only be for regarding cells that are listed under “COMPLETED TRANSACTIONS” (row 77) but will vary month to month)

So in this example, we’ll use the docket # C-086-030

What I need is for C-086-030 Plates customer billed data(cell L83) to be transferred to another work book. I also need C-086-030 Plates reversal data(cell O83) to be transferred to another work book

What I need is for C-086-030 Art added with Seps (L88+L84) And then that data to be transferred to another work book. I also need C-086-030 Art added with Seps (O88+O844) reversal data, to be transferred to another work book
----
The other work book…
I have put info where the cells should go for the macro. Then the other formulas on it should do the rest.

--- So basically, on the "plate’s" spreadsheet, when someone adds a new row with either a plate, seps and/or art data (for the same docket #) , then that data in the corresponding cell should be recognized by the automatic macro, transferred and calculated into the "graphics" spreadsheet.

I think it its extremely difficult to do, but hopefully someone out there will help me.
Please if you need more information don’t hesitate to reply.
You're the BEST!

Thank you!