Pull data based on user input

[mani_bbc05]

Hi Friends,

By using VBA, I am supposed to pull data based on user input, Column is fixed but rows are not fixed.

Based on cell value C5 to C8 (Values will change), data main table should get filtered out

I have attached example file with more details


Thanks & Regards

 

[Abdul Matheen]

Hi Mani,

Could you please explains briefly the filter types and also give one sample result data, the result table which is there in the workbook is not matching the condition which you explained in the workbook.

Regards
Abdul Matheen

 

[Abhijeet R. Joshi]

Adding to what Abdul rightly mentioned, it would be great if you could tell us will criteria should be applied to which column.

For instance:
C5 to Col.A , C6 to Col.B and more on....

 

[mani_bbc05]

Thanks friends for all your help, i have found another way for the above problem. Anyway thanks for your messages.

 

[SirJB7]

Hi, mani_bbc05!
Maybe you want to share your solution with the community, so as people who read this would have the issue or question and the solution or answer as well.
Regards!

 

[BKGirl]

Project - When team members chooses from the drop down box in workbook ‘Product Development Phases’ (column B 8), that it automatically loads this same information in the ‘Detailed Project Master List’ worksheet of the workbook ‘Working spreadsheet 011314’ in column J – according to the Project name provided in column B 5 from ‘Product Development Phases’. Project names will correspond with column E. (I had begun to work on this, not sure if this is in the format for a macro).
a. (Question – can an ‘if, then, else’ statement be used in a nested function/macro for this question)