Repeating Entries

G

Gary F

How does one set up certain fields in a template so that
entries will be repeated across multiple worksheets for
certain cells???
 
D

Dave Peterson

Use a formula to refer to that repeated value:

If A1 of every sheet should change based on what's in Sheet1 A1, you can put a
formula like:

=sheet1!a1
in A1 of all the sheets (well, not sheet1)

And maybe better:
=if(sheet1!a1="","",sheet1!a1)

This'll stop showing a 0 when sheet1!a1 is empty.
 
Top