Macro for formatting columns with dates, weekdays, and widths?
Hi there,
I'm keeping an attendance sheet in Excel; each worksheet is a different
month, and usually with different kids, and fields in the top couple of
rows are dates (formatted like | 1/27 | 1/28 | etc.) and days of the
week (formatted like | S | M | etc.).
I want to make code or a macro that does the following on the click of
a button:
--copy all the data in the current month's (say January) worksheet,
--insert a new worksheet,
--past the data,
--format the page like the January worksheet,
--etc.
I know how to make a macro for this. I do NOT know how to
automatically do the following:
--name the worksheet's tab with the name of the next month,
--realign the days of the week with the new dates (these are on
separate rows),
--and then automatically resize all the columns such that columns with
the date 1/27 take up more space (1 character) more than columns with
single digit dates, like 1/9.
--lastly, delete or hide Saturday and Sunday columns between weeks.
Space is critical--each page must fit within the margins of a
letter-sized piece of paper.
Hoped I described this ok. Thanks in advance for your
assistance/advice.
Arnold
|