Method to select row and hide others

[Corleone]

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

 

[BrianB]

I suggest you use Data/Filter/Autofilter and record a macro if required to automate the selection.