| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying from worksheet to worksheet
I want to start a new worksheet with the ending data from my old
worksheet. I'll continue to enter data into the old worksheet, but I want it to copy into the new one as well. I tried using sheet1!F384 for example, but all that does is put in the date 1/9/00 Confused |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying from worksheet to worksheet
=IF(Sheet1!F384="","",Sheet1!F384)
Gord Dibben MS Excel MVP On Wed, 19 Mar 2008 11:46:59 -0700, spilparc wrote: I want to start a new worksheet with the ending data from my old worksheet. I'll continue to enter data into the old worksheet, but I want it to copy into the new one as well. I tried using sheet1!F384 for example, but all that does is put in the date 1/9/00 Confused |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying from worksheet to worksheet
Thank you. Is there a way to have it include the same formatting as
well? On Wed, 19 Mar 2008 13:32:47 -0700, Gord Dibben <gorddibbATshawDOTca wrote: =IF(Sheet1!F384="","",Sheet1!F384) Gord Dibben MS Excel MVP On Wed, 19 Mar 2008 11:46:59 -0700, spilparc wrote: I want to start a new worksheet with the ending data from my old worksheet. I'll continue to enter data into the old worksheet, but I want it to copy into the new one as well. I tried using sheet1!F384 for example, but all that does is put in the date 1/9/00 Confused |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying from worksheet to worksheet
Not without some added work.
Formatting cannot be linked. You could use some Conditional Formatting to format the source cell and use the same CF for the target cell. But only visual formatting like Patterns, Fonts, Borders, not formatting like number formatting or dates or similar. Gord On Wed, 19 Mar 2008 14:43:12 -0700, spilparc wrote: Thank you. Is there a way to have it include the same formatting as well? On Wed, 19 Mar 2008 13:32:47 -0700, Gord Dibben <gorddibbATshawDOTca wrote: =IF(Sheet1!F384="","",Sheet1!F384) Gord Dibben MS Excel MVP On Wed, 19 Mar 2008 11:46:59 -0700, spilparc wrote: I want to start a new worksheet with the ending data from my old worksheet. I'll continue to enter data into the old worksheet, but I want it to copy into the new one as well. I tried using sheet1!F384 for example, but all that does is put in the date 1/9/00 Confused |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a formula from one worksheet to another worksheet | Excel Worksheet Functions | |||
| Looking up a variable in one worksheet and copying information from another column to another worksheet?? | Excel Discussion (Misc queries) | |||
| Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
| Copying all formats from worksheet to worksheet | Excel Worksheet Functions | |||
| copying formulas from worksheet to worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
