RE: $$Excel-Macros$$ EXTRACTING DATA BASE ON MATCHING VALUE

2012-04-17 Thread Siraj Momin (BTG)
Behalf Of dguillett1 Sent: Tuesday, April 17, 2012 6:14 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ EXTRACTING DATA BASE ON MATCHING VALUE You did not provide an example but I would suggest you only use ONE sheet and simply use data>filter>autofilter to filter th

Re: $$Excel-Macros$$ EXTRACTING DATA BASE ON MATCHING VALUE

2012-04-17 Thread dguillett1
guille...@gmail.com From: Siraj Momin (BTG) Sent: Tuesday, April 17, 2012 4:34 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ EXTRACTING DATA BASE ON MATCHING VALUE DEAR SIR, I HAVE TWO SHEETS ONE PROGRESS TRACKING DATA AND REPORT-INDEX I WANT TO CAPTURE DATA FROM PROGRESS TRAKIN

$$Excel-Macros$$ EXTRACTING DATA BASE ON MATCHING VALUE

2012-04-17 Thread Siraj Momin (BTG)
DEAR SIR, I HAVE TWO SHEETS ONE PROGRESS TRACKING DATA AND REPORT-INDEX I WANT TO CAPTURE DATA FROM PROGRESS TRAKING DATA SHEET IF COL (I1) OF REPORT-INDEX MATCHES WITH COL(P) OF PROGRESS TRACKING DATA IT SHOULD LIST ALL ROWS WHICH MATCHES BUT ONLY THOSE COLUMN WHICH'S HEADING (COLORED GRE