TAB1 has various data across from column A-J.
In Column A, i have a date and in Column J i have the same date plus 7 days with a whole load of other stuff in between.
In TAB2, i want to select a month in CELL A1 and have the lines below show the data from TAB1 where the date in Column J falls within that month.
In case i haven't explained that very well:
TAB1:
A B C D J
1 01/01/2018 SH31 ENG Accounts Early 08/01/2018
2 15/01/2018 FG19 SCO Cleansing Late 22/01/2018
3 25/01/2018 TY51 WAL Engineering Early 01/02/2018
If i now select "January" in TAB2 A1, the data below should come back with the first 2 lines from TAB1 (above).
Thanks in advance for your help.
In Column A, i have a date and in Column J i have the same date plus 7 days with a whole load of other stuff in between.
In TAB2, i want to select a month in CELL A1 and have the lines below show the data from TAB1 where the date in Column J falls within that month.
In case i haven't explained that very well:
TAB1:
A B C D J
1 01/01/2018 SH31 ENG Accounts Early 08/01/2018
2 15/01/2018 FG19 SCO Cleansing Late 22/01/2018
3 25/01/2018 TY51 WAL Engineering Early 01/02/2018
If i now select "January" in TAB2 A1, the data below should come back with the first 2 lines from TAB1 (above).
Thanks in advance for your help.
Last edited: