Hi all,
Can I bother you with this Macro?
I have 3 sheets and I would like a macro to copy the Value on "Copy Source Sheet" Cell E3 to my other Sheets; Copy Here1 and Copy Here2 .
Currently the area where the copied value should be pasted contains the value "-" , I would like to paste the copied value on Column D where the first instance "-" appears.
Appreciate any help. I have attached my sample worksheet.
Thank you very much.
Bookmarks