Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round dates to weekdays | Excel Worksheet Functions | |||
Weekdays between two dates in Excel? | Excel Discussion (Misc queries) | |||
Difference (weekdays) between two dates | Excel Worksheet Functions | |||
Fill dates with weekdays/workdays only | Excel Worksheet Functions | |||
Calculate weekdays from two dates | Excel Programming |