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)
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.
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
Bookmarks