Hi,
Here is a macro that I use to pick up some values from one worksheet (PG Calculator) from a number of cells and add them to a new row on another worksheet (PGmixlist).
One or two of the general formatted cells may be empty and thats fine they are copied across as empty. The output worksheet (PGmixlist) show the cells as empty, which is what I need.
However, when I recall the records from a dropdown list it repopulates the original worksheet (PG Calculator) with the values but the empty cells come back as zeros. I need them to be empty. I've tried different cell formats general, text but I get the same result, zeros.
any ideas please?
here is a cell formula that picks up the value based on the name from the drop down list.
Bookmarks