Auto fill references

[claytorm]

Another question:

Main sheet has list of values in col A starting with A2, e.g.

AAL
ABF
ABG


I want to create a reference so that cell A1 in Sheet 2 of the workbook links to A2 in the Main sheet, i.e. "AAL". A1 in Sheet 3 would link to A3 in the Main sheet, i.e. "ABF", and so on. Given that there are 300 + sheets, I don't want to do this manually. If any of you can help, I'd really appreciate it.

Bertie.

[Jim Rech]

There is no function in Excel that does this so you'd have to do it by
macro:

Sub a()
Dim Counter As Integer
For Counter = 2 To Worksheets.Count
With Worksheets(Counter)
.Cells(1).Formula = "=" & Worksheets(1).Name & "!A" & .Index
End With
Next
End Sub


--
Jim
"claytorm" <[email protected]> wrote in
message news:[email protected]...
>
> Another question:
>
> Main sheet has list of values in col A starting with A2, e.g.
>
> AAL
> ABF
> ABG
>
>
> I want to create a reference so that cell A1 in Sheet 2 of the workbook
> links to A2 in the Main sheet, i.e. "AAL". A1 in Sheet 3 would link to
> A3 in the Main sheet, i.e. "ABF", and so on. Given that there are 300 +
> sheets, I don't want to do this manually. If any of you can help, I'd
> really appreciate it.
>
> Bertie.
>
>
> --
> claytorm
> ------------------------------------------------------------------------
> claytorm's Profile:
> http://www.excelforum.com/member.php...o&userid=11610
> View this thread: http://www.excelforum.com/showthread...hreadid=480244
>