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.

Please don't multipost.



Craig wrote:

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.

--

Dave Peterson

You have replies elsewhere - please do not multipost.

Pete

On Jan 19, 11:16*pm, Craig wrote:
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.

On Jan 19, 6:53*pm, Pete_UK wrote:
You have replies elsewhere - please do not multipost.

Pete

On Jan 19, 11:16*pm, Craig wrote:



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.- Hide quoted text -

- Show quoted text -

ok sorry no more multi posting

and please don't bottom post.

regards
FSt1

"Craig" wrote:

On Jan 19, 6:53 pm, Pete_UK wrote:
You have replies elsewhere - please do not multipost.

Pete

On Jan 19, 11:16 pm, Craig wrote:



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.- Hide quoted text -

- Show quoted text -

ok sorry no more multi posting

On Jan 19, 8:04*pm, FSt1 wrote:
and please don't bottom post.

regards
FSt1



"Craig" wrote:
On Jan 19, 6:53 pm, Pete_UK wrote:
You have replies elsewhere - please do not multipost.

Pete

On Jan 19, 11:16 pm, Craig wrote:

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.- Hide quoted text -

- Show quoted text -

ok sorry no more multi posting- Hide quoted text -

- Show quoted text -

jerk