auto copy from one sheet to another

  • Thread starter Thread starter Tom 15
  • Start date Start date
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.
 
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.
 
You must log in or register to reply here.

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

Similar Threads

how do I change lookup sheet within formula? 1
Dispaly results, rather than a formula 2
summary values across worksheets within the same workbook 2
Populate Data from Summary Sheet 5
copying macros to other sheets 3
Copy Unique Record 2
How to refer to a range except one cell 4
Summary sheet returning #value! 1

Back
Top