VBA code for reports from all sheets in a workbook

sushilkadam

New Member
Joined
Mar 14, 2016
Messages
14
Hi Everyone,:cool:

I am in urgent need of vba code for my reports

Attached is the sheet of my documents I get it from different vendors. Column AA contains the different status (e.g. Pending from vendor, Pending for OGC response, Pending for OGC submission etc. etc.)

I want to have a report section, wherein by selecting one type of status I will get list of all documents under that particular status in all sheets of my workbook

For example: If I select status as “Pending for OGC Response” than I shall get list of all documents that are in this status
If “Pending for OGC Response” is in cell AA13 than I shall get the details of A13, B13, C13, D13 and so on till AA13 under heading mentioned in Row-10

Please note code is required for all sheets in the workbook and not only for one sheet

Hope you all understood my requirement and will be very thankful for your help
Any thoughts are most welcome

Thanks:)
Sushil Kadam
 

Forum statistics

Threads
1,085,494
Messages
5,383,990
Members
401,869
Latest member
raikks

Some videos you may like

This Week's Hot Topics

Top