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