Getting rid of blank rows withouth deleting them

S

samsg

Hi, i have a list that looks like this

22

43
22

41
...

I need the list to be together

22
43
22
41
...

However i can't use a macro or something to delete the entire ro
because other worksheets are related to the cells, so when i delte th
row, the #ref thing apears, somebody know a formula or something tha
can help me? Thanks a lo
 
Top