Repeating entries

  • Thread starter Thread starter Gary Fitz
  • Start date Start date
G

Gary Fitz

How does one set up certain fields in a template so that
entries will be repeated across multiple worksheets for
certain cells???
 
is the answer as easy as:

in sheet2, cell a1 enter "=+Sheet1!A1" w/o quotes

This will give you whatever is entered in sheet1, cell a1.
 
If I understand you correctly....

If, for example, the first cell you type data into is A2
on Sheet1, wherever you want that info repeated you simply
type the equal sign in the cell where you want it to copy
to and then click in A2 of Sheet1, so the formula would
end up looking like this:

=Sheet1!A2
 
Back
Top