Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
QUERY ABOUT DATA REQUIRE
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
QUERY ABOUT DATA REQUIRE
DEAR SIR,
I KNOW BUT I AM TRYING THROUGH VBA CODE? FROM : RASHESH "Kassie" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel, how can I require a field to contain data? | Excel Discussion (Misc queries) | |||
Data Validation- Require Entry in a Field | Excel Discussion (Misc queries) | |||
Require help related to Excel Query outer join problem | Excel Discussion (Misc queries) | |||
Require Minimum Amount When Entering Data | Excel Worksheet Functions | |||
external web query? (sites that require login) | Excel Discussion (Misc queries) |