Using Autofill to continue a sequence

  • Thread starter Thread starter DannyJ
  • Start date Start date
D

DannyJ

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
 
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
 
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
 
Back
Top