QUERY ABOUT DATA REQUIRE

DEAR SIR,

I HAVE A EXCEL WORKSHEET IN ROW,COLUMN FORMAT BUT I REQUIRE FOR PARTICULAR
COLUMN DATA OF SOME OF ROW. FOR BELOW EXAMPLE:

COL - A
COL - B
COL - C
COL - D

NAME
XXXX MAN

1

ADDRESS
XXX SOC

2

ADDRESS
DDD STREET

2

CITY
KKKK

2

MMM
REGI NO

3

KK
DATE

4




5

QQ0001
QUERY
1500
6

A52411
JAKAS MM
1700
6

QWWWW
JECKY
5000
6

MNN
MANU
15000
7

MQQQQ
MAYANK
2300
8



NOW, COL - D FOR PARTICULAR SECTION, IN THIS SECTION NO LIMIT FOR NO OF
DATA, NOW I WANT TO PARTICULAR SECTIONWISE DATA REQUIRE, SO HOW IS IT
POSIBLE?

FROM : RASHESH

Are you trying to filter data, so that only rows containing a specific value
in Col D is shown?

I see you have a couple of 6's in this column

If so, and if your data is in A2:D?, then select A1:D?. Now click on
Data|Filter and then on Auto Filter. Click the Down arrow in Col D, and
select eg 6. You will only see the three rows containing a 6 in Col D

"RASHESH" wrote:

> DEAR SIR,
>
> I HAVE A EXCEL WORKSHEET IN ROW,COLUMN FORMAT BUT I REQUIRE FOR PARTICULAR
> COLUMN DATA OF SOME OF ROW. FOR BELOW EXAMPLE:
>
> COL - A
> COL - B
> COL - C
> COL - D
>
> NAME
> XXXX MAN
>
> 1
>
> ADDRESS
> XXX SOC
>
> 2
>
> ADDRESS
> DDD STREET
>
> 2
>
> CITY
> KKKK
>
> 2
>
> MMM
> REGI NO
>
> 3
>
> KK
> DATE
>
> 4
>
>
>
>
> 5
>
> QQ0001
> QUERY
> 1500
> 6
>
> A52411
> JAKAS MM
> 1700
> 6
>
> QWWWW
> JECKY
> 5000
> 6
>
> MNN
> MANU
> 15000
> 7
>
> MQQQQ
> MAYANK
> 2300
> 8
>
>
>
> NOW, COL - D FOR PARTICULAR SECTION, IN THIS SECTION NO LIMIT FOR NO OF
> DATA, NOW I WANT TO PARTICULAR SECTIONWISE DATA REQUIRE, SO HOW IS IT
> POSIBLE?
>
> FROM : RASHESH
>
>
>

DEAR SIR,

I KNOW BUT I AM TRYING THROUGH VBA CODE?

FROM : RASHESH

"Kassie" <[email protected]> wrote in message
news:[email protected]...
> Are you trying to filter data, so that only rows containing a specific
value
> in Col D is shown?
>
> I see you have a couple of 6's in this column
>
> If so, and if your data is in A2:D?, then select A1:D?. Now click on
> Data|Filter and then on Auto Filter. Click the Down arrow in Col D, and
> select eg 6. You will only see the three rows containing a 6 in Col D
>
> "RASHESH" wrote:
>
> > DEAR SIR,
> >
> > I HAVE A EXCEL WORKSHEET IN ROW,COLUMN FORMAT BUT I REQUIRE FOR
PARTICULAR
> > COLUMN DATA OF SOME OF ROW. FOR BELOW EXAMPLE:
> >
> > COL - A
> > COL - B
> > COL - C
> > COL - D
> >
> > NAME
> > XXXX MAN
> >
> > 1
> >
> > ADDRESS
> > XXX SOC
> >
> > 2
> >
> > ADDRESS
> > DDD STREET
> >
> > 2
> >
> > CITY
> > KKKK
> >
> > 2
> >
> > MMM
> > REGI NO
> >
> > 3
> >
> > KK
> > DATE
> >
> > 4
> >
> >
> >
> >
> > 5
> >
> > QQ0001
> > QUERY
> > 1500
> > 6
> >
> > A52411
> > JAKAS MM
> > 1700
> > 6
> >
> > QWWWW
> > JECKY
> > 5000
> > 6
> >
> > MNN
> > MANU
> > 15000
> > 7
> >
> > MQQQQ
> > MAYANK
> > 2300
> > 8
> >
> >
> >
> > NOW, COL - D FOR PARTICULAR SECTION, IN THIS SECTION NO LIMIT FOR NO
OF
> > DATA, NOW I WANT TO PARTICULAR SECTIONWISE DATA REQUIRE, SO HOW IS IT
> > POSIBLE?
> >
> > FROM : RASHESH
> >
> >
> >