Can someone please assist.
I have a workbook with 8 sheets. (Main, Monday,Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday)
All sheets except Main are hidden. In cell B2 of Main is a date. I want to open a sheet that corresponds to the day of the date in cell B2, and hide all the rest, and then paste the date into G1 of the visible worksheet.
To clarify, if Main B2 was Saturday 4 September 2010, Main would get hidden and Saturday would be made visible and the date from B2 would then be pasted into cell G1 of the visible (Saturday) worksheet.
Thanks in advance
Koala