| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying data from other worksheet including entire format
Hello
I am using the following formula in hopes of copying the data over including the format into another worksheet called Early. In the worksheet called Early I have placed the following formula in A5. =Schedule!A5 A5 in the Schedule worksheet has this fields format as Custom mm/dd/yyy. The data in the Early worksheet is a number and the format is just GENERAL. How does one use a formula to bring over the formatting as well? I have this in other cells as well in the worksheet Early where I am expecting the formatting and the color to be copied over but it isn't doing that. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I copy an entire worksheet to another with text & format? | Excel Discussion (Misc queries) | |||
| Copying and using formulas including worksheet names | Excel Discussion (Misc queries) | |||
| Copying a region in excel results in the entire worksheet being pa | Excel Worksheet Functions | |||
| copying an entire worksheet - need absolute values | Excel Worksheet Functions | |||
| Copying worksheet but changing format | Excel Discussion (Misc queries) | |||
Hybrid Mode
