| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto copy from one sheet to another
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto copy from one sheet to another
hi
=Sheet1!B45 regards FSt1 "Tom 15" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto copy from one sheet to another
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. -- Cheers, Shane Devenshire "Tom 15" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Copy Text from one work sheet to another | Excel Worksheet Functions | |||
| Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
| Auto "copy and paste" individual cells from various sheets into one sheet ?? | Excel Discussion (Misc queries) | |||
| Auto copy data from 1 sheet into another | Excel Discussion (Misc queries) | |||
| How do I auto copy text in a cell from one sheet to another | Excel Worksheet Functions | |||
Hybrid Mode
