Autofill help!

[Rick88]

Is there a way to get this formula to autofill?

=if('9'!a73>0,'9'!a73,"") of course this references sheet 9, cell a73 but I want the next cell down to use the following formula;
=if('10'!a73>0,'10'!a73,"")

When I try to autofill this, it just changes the number 73 to 74, 75, etc.

Any help is greatly appreciated.

Thanks,
Rick

 

[Rick88]

You guys are geniuses, it worked perfectly (once I figured out what I was doing). It is going to be a time saver for sure.

Thanks to all who gave input, it is greatly appreciated.

Rick