VBA for Searching & Display record with Match Critaria

[santosh226001]

Sir,
I m a excel user...& works in India a road construction company..

i m maintaining a road record register.. where we store record

i want to a display VBA program which one show roads as per our 2-3 criteria

My Excel Sheet is enclosed..

looking for ur +ve response


Thanks In Advance

Santosh Shukla

[tehneXus]

hi try this: Road Register.xls

[santosh226001]

Sir Thank you very much for showing intrest in my project...

Sir ur VBA work as per my demand.. but after working i want litle bit change.. which is following

i want Filter Criatariya in Single Road instead of 4 rows .... so that we get more rows for displaying roads

I want All District & All Category option too in this VBA so that we get District or All Category information one time... if i want category wise display then we choose category in Filter Area

i m also enclosing PIC form in word doc so that u can easly understand what i want..

Thanks

[tehneXus]

please check if this works correctly:Road Register2.0.xls

[santosh226001]

HELLO.. sIR UR NEW FILE WORKS AS PER MY REQUIREMENT BUT ONLY ONE CHANGE... U DEFINE 4 FILED CRITERIA IN 4 FILED.. I WANT ALL 4 FILED CRITERIA IN ONE ROW SO THAT WE SHAVE 3 LINE.. HOPE U WILL HELP ME ONCE AGAIN....THANKS FOR UR ALL PREVIOUS HELP...

SANTOSH

[tehneXus]

try this: Road Register2.0.xls

Regards

[santosh226001]

Sir thank u very much for solving my excle problem with VBA... your provied VBA fullfill my all needs... but i have one problem.. in this sheet we provide u sample data.. but in our main master file we have more then 2000-3000 roads data.. so.. current time we show 10 RECORD THEN TOTALS
BUT IF WE HAVE MORE THEN 50 OR 100 RECORD SO WE WANT TOTALS LINE SHOW AFTER ENDING OF FILTERING DATA..

EX : IF FILTER DATA SHOW 8 RECORD THEN TOTAL SHOW IN 9TH LINE.. IF FILTER DATA SHOW 100 RECROD THEN TOTAL SHOW IN 101 LINE..

HOPE U UNDERSTAND WHAT I WANT

THANKS FOR YOUR VALUABLE SUPPORT

[santosh226001]

Sir thank u very much for solving my excle problem with VBA... your provied VBA fullfill my all needs... but i have one problem.. in this sheet we provide u sample data.. but in our main master file we have more then 2000-3000 roads data.. so.. current time we show 10 RECORD THEN TOTALS
BUT IF WE HAVE MORE THEN 50 OR 100 RECORD SO WE WANT TOTALS LINE SHOW AFTER ENDING OF FILTERING DATA..

EX : IF FILTER DATA SHOW 8 RECORD THEN TOTAL SHOW IN 9TH LINE.. IF FILTER DATA SHOW 100 RECROD THEN TOTAL SHOW IN 101 LINE..

HOPE U UNDERSTAND WHAT I WANT

THANKS FOR YOUR VALUABLE SUPPORT

[tehneXus]

how about: Road Register2.0.xlsm

[santosh226001]

sir ur provided xlsm file can't open in 2003 we dont have office 2007 pls send in 2003 format

[tehneXus]

sorry, use:Road Register2.0.xls

[santosh226001]

Sir Thank you Very much for you valuable Support...If we wannt few more change or add information in this project we will tell u.. u also help next time.. Thanks you So much sir..

[santosh226001]

Sir we facing a problem in ur provided vba.. which is following..

when we open file & press CTRL-F to type any road name in find diloge box ... DATA or Sheet1 We find Road name..

but

after run VBA programe.. any district.. again we want to find any road Find option not find road.. say MSEXcel can't find data?????

i think in VBA any Search event or command disable.. for false..

pls check

i m enclosing pic file for ur kind persual...

Thanks

[santosh226001]

Sir if if find error not solve.. then provide a find button and vba this that excel file so that we can find road in if 1000'0 of record in that sheet...

Thanks