Modifying Data on Another Worksheet

Hi there,

I need your help again.

I am trying to modify the code below in the attached excel doc, to make the "Add/Update" button on my userform to also make changes to the listed items in the "Inactive_Data" worksheet and not just the "Active_Data" worksheet like the code below was orginally intended to do so.

(Using Excel 2000 VBA)

Please Login or Register  to view this content.

The following code below will also need to be modified. I am really clueless as to how to modify it below, to only move the line of data from the "Active_Data" to "Inactive_Data" only if its listed in the "Active_Data" worksheet, otherwise, just make changes to the record.

Please Login or Register  to view this content.

For Ease of Reference, I have attached the Excel Document.

Any help is greatly appreciated on this, before I pull my entire hair out trying to figure this one out.

Thanks for all your help and support.

Jay