Hi, I am using the below code to copy cells from a list in the active sheet if they contains the same value as "K1".
I then call another macro (Sheet_Select) to select the sheet that is named the same as "K1".
When the sheet is selected I am pasting the copied cell to "A36".
This works but...