In attached file, on the “January” tab, I have tried to add additional columns (CL to CO) for the clinic named Walpole Street, which would display or be hidden if the checkbox is marked in the same way as other clinics do. However, when I create a macro similar to the other clinics/columns, it doesn’t seem to work.
I would like to correct this, then add three other sets of columns (with the same layout/structure as others). These additional columns should be inserted before the column “IST” (CP to CS) and be able to be displayed or hidden based on a checkbox on the left of the screen. Then these columns will need to be added to each of the other monthly tabs, so that they all have the same information.
Is it possible for the new columns and checkboxes to be entered alphabetically (as is the case for all the columns currently) instead of at the right of the spreadsheet? The three new groups of columns will be headed as "Northwood", "St. Lukes" and "Other" (although "Other" can be positioned to the left of "IST").
I’m sure that there is a quick and easy way to update the macro in place to do this, and probably another to copy these changes to the other tabs/worksheets.
Finally, when the “Reset Worksheet” is clicked, is there a way to remove the checkmarks from the boxes on the left of the screen?
Please let me know if the above does not make sense - it's a little tricky to explain exactly what I'm after.
Looking forward to helpful responses. Thank you!
Reply With Quote
