Repeating entries

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???
 
O

ozzie

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.
 
C

Connie

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top