K
Kash
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
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