Hi Guys
I am slowly but surely getting my spreadsheet to do my will.
I have a spreadsheet where colleagues will copy and paste data from an e-mail which will add data to my formulated columns it works fine however I need to copy my formula to the end of the columns which I have done, this is so my colleagues only need to paste data to make as basic as possible. The problem I have is until the data is copied by my colleagues the formulated cells will show N/a I would really like the sheet to appear blank so as not to confuse my colleagues is there any way to do this.
This needs to work in 2003 although using 2007
Thanks you in advance
Kellis
Bookmarks