Macro to move data from an input form to a datalog worksheet

I need a macro that will copy multiple individual cells to a data log sheet that doesn't require that all of the cells have content. In the code below when I add all of the cells to "mycopy" I get an error. In the attachment the cells that won't work are outlined in red.

Please Login or Register  to view this content.

looks to me that the red boxes are a problem because if there is an x in Use As Is for Procurement, it should give you Use As Is on your DataLogECN sheet in Column Q, if Rework then Rework, if Scrap then Scrap.

what you need to do is tell excel to look at those lines with something like

Please Login or Register  to view this content.

here's the whole code that fixes the Disposition of Materials section (the first red box)

Please Login or Register  to view this content.

i'm not sure what is supposed to be coming out of the Drawings affected section? there is a Drawings 2 column (col T) on the DataLogECN page but it is too small to have any meaningful information

ECN FORM - Copy.xlsm

i fixed everything except the drawings affected, since i didn't know what you were looking for in that section

let me know if you need anything changed?

Thank You very much I'll review it shortly and the drawings are an revision upgrades such as "A" to "B"

Scott,
Can we remove the "MsgBox" statement and move the range of cells to "MyCopy" so that the "ClearContents" would clear the entire form?

Scott here is what I finished with but I still don't like the double set of code at the end is there a way to combine them?

Please Login or Register  to view this content.