code to move cells back to thier original location

Hi everyone,

I am using the following code to move certain cells from one sheet to another. The user puts a name in a textbox, it then finds that name on the sheet and copies the correct cells over.

I would like a code which moves those cells back to thier original location (overwritting the existing). This code will be run after the user has made changes to the contents of the cells..

So for example...cells are in sheet1...below code pulls them to sheet2..the user makes changes to cell contents....the NEW code moves them back to thier original location, overwritting the existing.

Please Login or Register  to view this content.

Any ideas?

thanks for the reply, an example worksheet is attached.

Hi Guys,

any help with this one? please take a look at my example workbook and let me know.

bump?

thanks