hyperlinking within excel workbook

  • Thread starter Thread starter Rouja
  • Start date Start date
R

Rouja

I would like to create a formula that hyperlinks from row
1 of a worksheet to column 1 of another worksheet (same
workbook), row 2 to column 2, row 3 to column 3, and so
on. I can do that manually but that's not the goal. I've
tried hyperlink function and can't get it to work.

Any ideas?
 
Hi Rouja,

If I understood, you want to transpose rows to columns. Do this:
- On A1 cell of Sheet 2 put =OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1)
- Fill right on row 1;
- Fill down on each column.
 
Back
Top