The rows in the CPC file contain Product data records. The CPC file is formatted so all cells are locked but can be selected.
The user clicks on any cell within the row on the CPC sheet that he wants to change. I don't want the user to make any changes on the CPC sheet. I created the CE sheet to hold the current data in column B and the new data to be entered by the user for this product into column C. I need the cell contents on the CPC sheet of the selected row and columns A,B,C to be placed into sheet CE into cells B4, B5, and B6. I already have a macro to save this revised Product record into the CPC file and at the same time delete the old product record from the CPC file.
I don’t know how to make the macro move data from one cell in CPC to another cell on CE sheet per the above.