[EXCEL VBA] Insert a value or formula into empty cells in a range
I'm just looking at a spreadsheet for our personnel department and after having heard a quick grumble from another member of staff want to make it a bit easier for the end user.
It's a timesheet where the user fills in when they are in, off ill and so on (Image attached)Attachment 12704. To minimise the work of the end user I want to have them fill in the Off/Sick etc then have a button that looks at all the cells in the range and fills in the "I" in any cell that doesn't contain a value already. if possible I would also only like it to put values in cells where there is a member of staff and an actual day (i.e Febuary will only go up to the 28th and whilst my spreadsheet will automatically remove the 29/30/31 if if you set the month to "2" I don't want "I"'s what will be columns AD-AF
Any suggestions would be gratefully received.