To link this to Sheet2,
Enter this *anywhere* on Sheet2, and copy down as needed:
=INDEX(Sheet1!$1:$1,ROWS($1:1))
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
I need to paste link fron horizontal cells to vertical cells. tks
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.