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 |
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 |
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 |
All times are GMT +1. The time now is 08:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com