| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy date from worksheet to another worksheet (same File0
There are no formulas that will copy from one location to another--formulas can
retrieve a value from a cell in another worksheet, though. ='sheet 2'!a1 will retrieve the value from A1 from Sheet 2. If A1 on sheet 2 is empty, you'll see a 0. You may like this better: =if('sheet 2'!a1="","",'sheet 2'!a1) wamajkr wrote: i dont now fomula or ather to copy date from worksheet to another worksheet -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy worksheet to another worksheet and the date is plus 1 day. | Excel Worksheet Functions | |||
| Add worksheet Lookup based on date | Excel Worksheet Functions | |||
| How do I copy a date in a worksheet cell to another worksheet? | Excel Worksheet Functions | |||
| Worksheet Revision Date only once that day | Excel Discussion (Misc queries) | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Hybrid Mode
