I have aspreadsheet where in cell d2 I have the curret week ending date for
the weeks report (ie 27/2/04)
underneath this rom rows 4 to 34 I have 30 rows of data each has a week ending date in column a from 27/2/04 onwards
here is the query - how can I get the spreadsheet to automatically hide the rows which do not correspond with the date in cell d2 so that it is
just displaying the row indicated in d2
thanks
the weeks report (ie 27/2/04)
underneath this rom rows 4 to 34 I have 30 rows of data each has a week ending date in column a from 27/2/04 onwards
here is the query - how can I get the spreadsheet to automatically hide the rows which do not correspond with the date in cell d2 so that it is
just displaying the row indicated in d2
thanks