ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Autoarrange (https://www.excelbanter.com/excel-discussion-misc-queries/253591-autoarrange.html)

Sherees

Autoarrange
 
Hi

I have linked the columns of my sheet 3 with the columns of sheet 1. now
when i enter columns of sheet 1 the sheet 3 will update the same figure. I
need to arrange the sheet 3 (based on a column in descending order)
automatically, when I finish entering the sheet 1.
Pls help
Thanks & rgds

--
Life isa journey not a destination

Gary''s Student

Autoarrange
 
A small question. If the data in sheet1 was:

1
3
8
4
2

Do you want the data in sheet3 to appear in descending order:

8
4
3
2
1

or in reverse order:

2
4
8
3
1

--
Gary''s Student - gsnu200909


"Sherees" wrote:

Hi

I have linked the columns of my sheet 3 with the columns of sheet 1. now
when i enter columns of sheet 1 the sheet 3 will update the same figure. I
need to arrange the sheet 3 (based on a column in descending order)
automatically, when I finish entering the sheet 1.
Pls help
Thanks & rgds

--
Life isa journey not a destination


Sherees

Autoarrange
 
in descending order
--
Life isa journey not a destination


"Gary''s Student" wrote:

A small question. If the data in sheet1 was:

1
3
8
4
2

Do you want the data in sheet3 to appear in descending order:

8
4
3
2
1

or in reverse order:

2
4
8
3
1

--
Gary''s Student - gsnu200909


"Sherees" wrote:

Hi

I have linked the columns of my sheet 3 with the columns of sheet 1. now
when i enter columns of sheet 1 the sheet 3 will update the same figure. I
need to arrange the sheet 3 (based on a column in descending order)
automatically, when I finish entering the sheet 1.
Pls help
Thanks & rgds

--
Life isa journey not a destination



All times are GMT +1. The time now is 01:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com