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 |
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 |
All times are GMT +1. The time now is 07:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com