QUERY ABOUT DATA REQUIRE

[RASHESH]

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

 

[Guest]

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?, then select A1?. 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]

DEAR SIR,

I KNOW BUT I AM TRYING THROUGH VBA CODE?

FROM : RASHESH