Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Taking values from another cell
Thanks to everyone in advance..
I am taking values from one XL sheet and using them in another one (with a simple "=" function). However, values that are blank in the original sheet show up with a '0' in the new one. Is there a way for a blank to show up as a blank? (and if the original blank cell is filled then the new cell gets filled with that value?) I don't know any visual basic or anything like that, and I would prefer to avoid using macros... Thanks again |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Criterian Range taking value from another cell | Excel Discussion (Misc queries) | |||
REferencing a cell from another sheet... and taking it's coplour with it? | Excel Discussion (Misc queries) | |||
taking out lowest 2 values | Excel Worksheet Functions | |||
Taking the Mode based on cell value | Excel Discussion (Misc queries) | |||
Taking the mode based on Cell value | Excel Discussion (Misc queries) |