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 |
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?
|
All times are GMT +1. The time now is 04:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com