| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
empty cell = above cell
Hi,
I have pivot tables that I need to convert into plain columns. So I copy and paste the values into a new worksheet. Is there a way that I can (with a macro) fill in the blank cells with the value located in the cell right above? Keeping in mind that the cell length will vary... Thanks in advance! GĂ©raldine |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find first empty cell in column and start transpose next row in that cell | Excel Discussion (Misc queries) | |||
| format a cell with a formula so an empty reference cell shows blan | Excel Discussion (Misc queries) | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| VBA to copy to empty cell directly below a cell when analogous cells in different column have same value as each other? | Excel Programming | |||
| VBA to copy to empty cell directly below a cell when analogous cells in different column have same value as each other? | Excel Programming | |||
Threaded Mode
