What function can make cells shift up when they are blank?

J

Julie

Is there a function that can shift the cells up when they become blank? I
have a phone list that is by first and last name, and then one worksheet that
is by last and first name. One sheet I would like to have to update
information, and I want the other to automatically update when the first
sheet is changed. Also for the empty cells to shift up if they become empty?
Also, is there a function that can bring down cells from a second column and
bring it to the bottom of the first column?
Thank you,
Julie
 

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

Top