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