auto copy from one sheet to another

T

Tom 15

B45 on sheet called #1 gets put into c34 on sheet called summary?
What's the formula?



I'm not smart if you can keep it simple please.
 
S

ShaneDevenshire

Hi,

Make your life easier, don't type the formula, instead place your cursor in
C34 of the Summary sheet and type =
then click the sheet tab for Sheet1 and click on the cell B45.

When your formulas become longer or the sheet names are more complicated,
for example if they contain a space it is far easier to let Excel build them
by using the point and click method rather than typing out the formulas.
 
Top