Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I program excel to shift data up to fill empty cells?
I use Excel to create an invoice using questions. The user answers the
questions and using IF statements options are added to the invoice. The only problem is the invoice will have empty spaces between various options because the formula is in the cell but that option was not selected. How do I get the information to shift up and fill the cells |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I program excel to shift data up to fill empty cells?
Have you tried using Sort to move all the blanks to the end of the list?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find empty cells, fill with text from cell above | Excel Worksheet Functions | |||
Excel - Fill empty cells | Excel Worksheet Functions | |||
Macro Request: Fill in empty cells with previous Filled cell in column | Excel Worksheet Functions | |||
I need to fill only empty cells in a database with a symbol. | Excel Discussion (Misc queries) | |||
Fill-in empty cells from SAP report | Excel Worksheet Functions |