Hi all,
no amount of analysing recorded macros has helped me to figure out how to do what I need, so please can someone help?
I have sheet names in row 2. Let's say my active cell is row 5 column 7. I want to copy cells a5:e5 from the sheet name stored in column 7 row 2 to sheet display row 1 column 1.
I actually need to do a lot more but an answer to this will point me in the right direction..
Thanks,
H
no amount of analysing recorded macros has helped me to figure out how to do what I need, so please can someone help?
I have sheet names in row 2. Let's say my active cell is row 5 column 7. I want to copy cells a5:e5 from the sheet name stored in column 7 row 2 to sheet display row 1 column 1.
I actually need to do a lot more but an answer to this will point me in the right direction..
Thanks,
H