How to find search criteria2 if criteria1 not displayed in exccel by using
VBA
I have a workbook1-->Sheet3 having inputs(Iam providing 24monthdays:110,
125, 210,.......1210, 1225) for Marco.Input will be always Monthdays
regardless of years, on 10th and 25th of every month will receive data. If
mentioned days are not non-business day, suppose if 10th is holiday there
is possibility 11th to till 15th. Same way if 25th is holiday there is
possibility 26th to 30th of every month. Based on above conditions in
sheet1 needs to filter the data Eg: Monthday 110 I will search in sheet1.
Suppose sheet1 don't have data for mentioned "110" there is possibility
till "115"(But Ideally I am providing only 24th days in my input
"sheet3"). Please guide/help me regarding issue make vba.
No comments:
Post a Comment