RE: Indirect formula not working if I give custom name for Sheets

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Many thanks Mike. My next problem is to drag this formula to the rightward.
Now my formula is =INDIRECT($A3 & "!A6"). A6 does not chage in to B6! if I
drag to the right. Is there any method?
Thanks.

"Mike H" wrote:

Hi,

The mistake you are making is that you not providing a sheet name in the
formula.

there are ways of solving this. for example the formula below and a list of
sheet names in c1 down woould work

=INDIRECT(C1 & "!A6")

Mike

"Narnimar" wrote:

My sheets names are 1, 2, 3,... 100. I am trying to make a "summery" sheet in
the same work book from cells a6 to j6 from 1 to more than 100 numeric named
sheets.The formula =INDIRECT("Sheet" & (ROW()) & "!A6") is working fine if
the sheet names are from system default Sheet1, sheet2 sheet3 etc.

Now I modified the formula into =INDIRECT("'" & (ROW()) & "!A6") but it
returns #REF!. I dont know what is the mistake I am doing! Can any one solve
this problem?
.

Relevant Pages

  • RE: Adding Two Columns Together
    ... know about the "Fill Handle" Mike. ... So I simply created a new sheet. ... the First sheet which inclucde "Date, Ref Type, Amount, etc). ... you need to drag your formula down as far as your data extends. ...
    (microsoft.public.excel.misc)
  • RE: Indirect formula not working if I give custom name for Sheets
    ... "Narnimar" wrote: ... drag to the right. ... The mistake you are making is that you not providing a sheet name in the ... I dont know what is the mistake I am doing! ...
    (microsoft.public.excel.misc)
  • RE: Sheet renaming and use as data
    ... "Mike H" wrote: ... Drag down as required ... How can I get the formula to get the sheet name from the list that was ... Sub standard() ...
    (microsoft.public.excel.misc)
  • RE: Linking IF formulas between 2 sheets
    ... Thanks for that...it works for some of the cells, but in some cases the A's ... on Sheet 1 aren't the same as the A's on Sheet 2 so it leaves a blank. ... "Mike H" wrote: ... Drag down as required ...
    (microsoft.public.excel.misc)
  • Re: Campground Reservations: A lesson learned
    ... I just thought I would let some of you learn from my mistake since I ... Oh Mike, how I envy your Better Half! ... Maine, along the coast, for an interview in early Fall. ... need my help or my scheduling, they'd take care of their own sleeping ...
    (rec.outdoors.rv-travel)