Hyperlink dragging

Maybe?:

=HYPERLINK("G:\2010-2011\Time Table 2010 - 2011.xlsx - 'Lecture Hours'!B"&COLUMNS($A$1:G$1), COLUMNS($A$1:F$1))

Did the formula work as it stood?

I understand what you want to do, but wanted to know if the original formula you posted worked for you before I posted by suggestion?

Try:

Please Login or Register  to view this content.

COLUMNS() is a function that counts how many columns are between two cell references.

So I am basically using that as a counter to determine "the number" of interest as I copy across

COLUMNS($A$1:G$1) equals 7 because there are 7 columns between A1 and G1

and COLUMNS($A$1:F$1) equals 6 because there are 6 columns between A1 and F1.

When we drag this over one cell they turn to:

COLUMNS($A$1:H$1) and COLUMNS($A$1:G$1), respectivel for 8 and 7, respectively.

The $ freezes the column or row reference... so you will note that there is no $ in front of the second cell reference in the range... this is so that as we copy across only that column letter is allowed to change, allowing for the incremental count.

In the second row you would start with:

COLUMNS($A$1:M$1) and COLUMNS($A$1:L$1),

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save