| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicating Excel templates
Thanks that helps.
"Dave Peterson" wrote: Maybe??? Can you use a formula like: =if(sheet2!a1="","",sheet2!a1) (the balance has to be in the same location if you use the address) Maybe define a name for that cell with the balance (insert|Name|Define) =if(myBalance="","",myBalance) Personally, I like to keep all my data in one worksheet. Jeffrey wrote: Thanks, that was what I was looking for. Now one more question, how do tou bring forward the balance from the first worksheet to the second one. "Dave Peterson" wrote: ctrl-Click on the worksheet tab and drag to the right or left. You'll be copying the worksheet. If you meant you want to copy to another workbook, select the worksheet edit|move or copy sheet|check copy and point at a new/existing workbook. Jeffrey wrote: I have been using a Billing Statement template that I down load and I am trying to copy it to another worksheet. But when I do it does not look like the original. How do I do this or copy it as a secong page without losing the format? -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel Templates | Excel Discussion (Misc queries) | |||
| HOW DO I DOWNLOAD TEMPLATES FOR EXCEL? | Excel Discussion (Misc queries) | |||
| excel templates for gradebook | Excel Worksheet Functions | |||
| why templates do not load into excel 2000? | Excel Discussion (Misc queries) | |||
Hybrid Mode
