PASTE LINK FROM HORIZONTAL CELLS TO VERTICAL CELLS

R

RagDyeR

Original data on Sheet1, Row1
A1 to whatever.

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.

Ask a Question

Similar Threads

need to paste link from 4 vertical cells to 4 horizontal cells? 6
Configuration of cells 5
Can I prevent vertical table lines from printing? 2
Borders Rotating 90 Degrees 1
How to Convert same horizontal row to vertical row in Excel? 3
Print 3
HOW DO I SHOW ONLY THE CELLS USED IN THE WORKSHEET INSTEAD OF THE. 2
horizontal lines to vertical 5

Top