mike31z
04-30-2007, 04:49 PM
I solved my earlier problem of copying data from one sheet to another were the data is not in numerical sequence by using the Vlookup thanks to (mdmackillop). Here is a follow on problem; Because there are formulas on numerous cell with out data the result is "#N/A"
Is there a way to hide the "#N/A" entry?
My solution is to create a macro to color all the cell that equal "#N/A" to white so that they are not seen on the connected tv monitor that allows people to see there scores.
Any other ideas?
PS: I can live with the "#N/A" but if there is away to hide them that the ticket because it will reduce question by the non excel people wiewing the data.
Also the "#N/A" don't need to be printed when reports are created.
Mike in wisconsin
Is there a way to hide the "#N/A" entry?
My solution is to create a macro to color all the cell that equal "#N/A" to white so that they are not seen on the connected tv monitor that allows people to see there scores.
Any other ideas?
PS: I can live with the "#N/A" but if there is away to hide them that the ticket because it will reduce question by the non excel people wiewing the data.
Also the "#N/A" don't need to be printed when reports are created.
Mike in wisconsin