How can I program excel to shift data up to fill empty cells?

H

Howlingstraycat

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Look Up Formula With Veried Search Range 2
Page numbering with Merged Document and IF statements 1
Macros to check whether all cells are filled 0
v look up formula to generate a blank line 1
Creating Labels Over 3-Up Image 2
Can't "Shift Cells Up" anymore? why? 1
Cumulatively list data from each new worksheet 1
shifting of data to fill into blank cells 3

Top