Sorting problem

[Craig]

After I sort ascending a worksheet within a workbook the first 30 rows
are blank.

I have a workbook with 4 worksheets and I want info to update from the
first one through all the others so I highlight A1 - 60L and paste
special as a link to each sheet.

I enter 30 rows of info on my 1st sheet and all the other sheets are
updated.

The problem comes when I sort ascending according to a column in any
of the linked worksheets there are 30 rows of blank space on top. I
would like to have the blank space on the bottom.

This must have something to do with sorting by starting out with
zeros.
Can I create a macro or change a setting to compensate for this.

If this doesn't make any sense please tell me, I will try to
rephrase.
If I am in the wrong group please tell me and I will post elsewhere.

 

[Pete_UK]

I think you will find that those blank rows are not truly blank - the
cells in the sort column will contain a formula blank (i.e. a fomula
returns ""), or even spaces. If they are meant to be blank and you
don't want them, then you can highlight the rows and Edit | Delete to
get rid of them after the sort.

Hope this helps.

Pete

 

[Craig]

I think you will find that those blank rows are not truly blank - the
cells in the sort column will contain a formula blank (i.e. a fomula
returns ""), or even spaces. If they are meant to be blank and you
don't want them, then you can highlight the rows and Edit | Delete to
get rid of them after the sort.

Hope this helps.

Pete








- Show quoted text -

Thanks for the reply
I do not wish to delete them because they are active linked cells. I
only want to have then located below the written cells. I have been
cutting then inserting cut cells below the written cells but I want
to automate this process
Thanks again for the reply

 

[pub]

Thanks for the reply
I do not wish to delete them because they are active linked cells. I
only want to have then located below the written cells. I have been
cutting then inserting cut cells below the written cells but I want
to automate this process
Thanks again for the reply

if upi use Excel 2007. you can use conditional formatting, and give the
rows a color (even white will work if you dont want to see a color).
then you can do your 1st sort by color with the color at the top or
bottom (depending on how you set your conditional formatting).