Get data - Multiple criteria
 

Hello there..

I am trying to get some data from sheet 'April' to Sheet 'Search' using
macros..

Its like people can select some criteria's to get the data.

1. if Sheets("Search").Range("E4").value="First" then it should search for
Sheets("Search").Range("C4").value in Sheets("April") column 'J'

and also match Sheets("Search").Range("C2").value with Sheets("April")
column 'F'.

It should also check if Sheets("Search").Range("E4").value="3Months"
then it should only get the data which is within 90 days, date column in
Sheets("April") is 'I'

2. if Sheets("Search").Range("E4").value="Second" then it should search for
Sheets("Search").Range("C4").value in Sheets("April") column 'M' and other 2
conditions remain the same.

P S - If any of these are left blank without selecting any option then that
criteria should be skipped.

Thank you