Active worksheet opens a new sheet from which I input data that needs to go back to the worksheet I came from

[Brutium]

I hope someone can help me.
I need a code that will allow me to move data from a worksheet to a worksheet from which I came from. e.g. worksheet "Sheet 6" opens "Sheet 10", then after filling data in "Sheet 10" I need to move this data back to "Sheet 6" in the cells in range "F12 to F56". Please note that the data in "Sheet 10" is in the same range as in "Sheet 6"

How can I accomplish this?

Thanks

 

[vw412]

Can you give us a sample of the workbook? If this is strictly Sheet6 to Sheet10 then copy back to Sheet6 then it is easy to hard code that. But, if you want it to be generalized for any sheet to any sheet, we have a different problem.