| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying data to different Cells
i wantto copy data from a front work sheet to different work sheets i am
using the copy function then paste options link cells. this iscopyingthe data across fine but empty cells are being filled with a 0 or default date, how do i ensure that these fields stay blank as in the original sheet |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copying data to different Cells
You'll have to change the formula:
=sheet99!a1 becomes =if(sheet99!a1="","",sheet99!a1) Auz wrote: i wantto copy data from a front work sheet to different work sheets i am using the copy function then paste options link cells. this iscopyingthe data across fine but empty cells are being filled with a 0 or default date, how do i ensure that these fields stay blank as in the original sheet -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting data from different cells for a chart | Charts and Charting in Excel | |||
| renaming data labels by different cells than source data | Charts and Charting in Excel | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
Linear Mode
