I am trying to help a friend "spiffy" up a sign up sheet. I haven't done any
programming in 10 years, and then it was self-taught and only as a side
action to get my main job done.
He has an Autofilter on the Headings row so he can click on Tuesday, for
example, or Saturday, etc. There really isn't anything to identify the sheet
as Tuesday, for example, or Saturday, etc.
Would it be possible to start the cursor in, say, the Headings row, and then
move it down a cell at a time, checking each cell if it is visible or not,
then stopping at the first cell that is visible and copying the information
to the top of the page. That way a sheet could be indentified as Tues, or
Friday, etc. It would also preclude the need to create a separate page for
each day.
Would appreciate the help.
Thanks.