Good Morning people!
I need some help on something please,
I need to do a copy cell reference, but if the cell is blank, i want the cell to remain blank, but every thing i try either just returns a 0 or false statement.
EG.
A1 has a entry in it, and I want B1 to show the same, so i simply use in B1 =A1. but if A1 is blank, B1 returns a 0, but i want it to remain blank, so literually being a exact copy of the cell.
is this possible?
I need some help on something please,
I need to do a copy cell reference, but if the cell is blank, i want the cell to remain blank, but every thing i try either just returns a 0 or false statement.
EG.
A1 has a entry in it, and I want B1 to show the same, so i simply use in B1 =A1. but if A1 is blank, B1 returns a 0, but i want it to remain blank, so literually being a exact copy of the cell.
is this possible?
