Using Autofill to continue a sequence

Dear All,

I have a sequence which goes:-

=If('Name 1'!$AG$8>0,'Name 1'!$AG$8>0,"")
=If('Name 2'!$AG$8>0,'Name 2'!$AG$8>0,"")

The spreadsheet is large so if possible I would like to know if there is a
quick way of continuing the sequence.

e.g. =If('Name 3'!$AG$8>0,'Name 3'!$AG$8>0,"")

Anyone got any ideas?

Many thanks,

Danny

DannyJ,

Entered into a cell on row 3, then copied down. If not entered in row 3,
then adjust the $2:$2 to be one less than the actual row of entry.

=IF(INDIRECT("'Name " & ROW() -ROW($2:$2) & "'!$AG$8")>0,TRUE,"")

HTH,
Bernie
MS Excel MVP


"DannyJ" <[email protected]> wrote in message
news:[email protected]...
> Dear All,
>
> I have a sequence which goes:-
>
> =If('Name 1'!$AG$8>0,'Name 1'!$AG$8>0,"")
> =If('Name 2'!$AG$8>0,'Name 2'!$AG$8>0,"")
>
> The spreadsheet is large so if possible I would like to know if there is a
> quick way of continuing the sequence.
>
> e.g. =If('Name 3'!$AG$8>0,'Name 3'!$AG$8>0,"")
>
> Anyone got any ideas?
>
> Many thanks,
>
> Danny
>
>

Thanks a million I will try it and then try to figure out how it
works.....that I put in the wrong function in the first place does not help
of course (sorry). Basically I am trying to retrieve a value from another
worksheet and if the value is 0 leave the cell blank.

It should have been

=If('Name 1'!$AG$8>0,'Name 1'!$AG$8,"")
=If('Name 2'!$AG$8>0,'Name 2'!$AG$8,"")

Thanks again,

Danny

"Bernie Deitrick" <deitbe @ consumer dot org> wrote in message
news:[email protected]...
> DannyJ,
>
> Entered into a cell on row 3, then copied down. If not entered in row 3,
> then adjust the $2:$2 to be one less than the actual row of entry.
>
> =IF(INDIRECT("'Name " & ROW() -ROW($2:$2) & "'!$AG$8")>0,TRUE,"")
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "DannyJ" <[email protected]> wrote in message
> news:[email protected]...
> > Dear All,
> >
> > I have a sequence which goes:-
> >
> > =If('Name 1'!$AG$8>0,'Name 1'!$AG$8>0,"")
> > =If('Name 2'!$AG$8>0,'Name 2'!$AG$8>0,"")
> >
> > The spreadsheet is large so if possible I would like to know if there is
a
> > quick way of continuing the sequence.
> >
> > e.g. =If('Name 3'!$AG$8>0,'Name 3'!$AG$8>0,"")
> >
> > Anyone got any ideas?
> >
> > Many thanks,
> >
> > Danny
> >
> >
>
>

Hmm I tried the formula (for which many thanks) but it did not return true
values when it should have :-(

But thank you for your help.

Danny
"DannyJ" <[email protected]> wrote in message
news:[email protected]...
> Thanks a million I will try it and then try to figure out how it
> works.....that I put in the wrong function in the first place does not
help
> of course (sorry). Basically I am trying to retrieve a value from another
> worksheet and if the value is 0 leave the cell blank.
>
> It should have been
>
> =If('Name 1'!$AG$8>0,'Name 1'!$AG$8,"")
> =If('Name 2'!$AG$8>0,'Name 2'!$AG$8,"")
>
> Thanks again,
>
> Danny
>
> "Bernie Deitrick" <deitbe @ consumer dot org> wrote in message
> news:[email protected]...
> > DannyJ,
> >
> > Entered into a cell on row 3, then copied down. If not entered in row
3,
> > then adjust the $2:$2 to be one less than the actual row of entry.
> >
> > =IF(INDIRECT("'Name " & ROW() -ROW($2:$2) & "'!$AG$8")>0,TRUE,"")
> >
> > HTH,
> > Bernie
> > MS Excel MVP
> >
> >
> > "DannyJ" <[email protected]> wrote in message
> > news:[email protected]...
> > > Dear All,
> > >
> > > I have a sequence which goes:-
> > >
> > > =If('Name 1'!$AG$8>0,'Name 1'!$AG$8>0,"")
> > > =If('Name 2'!$AG$8>0,'Name 2'!$AG$8>0,"")
> > >
> > > The spreadsheet is large so if possible I would like to know if there
is
> a
> > > quick way of continuing the sequence.
> > >
> > > e.g. =If('Name 3'!$AG$8>0,'Name 3'!$AG$8>0,"")
> > >
> > > Anyone got any ideas?
> > >
> > > Many thanks,
> > >
> > > Danny
> > >
> > >
> >
> >
>
>