VBA Help Please.


Well-known Member
Apr 7, 2005
I've come up with the code below that consolidates time-off requests made by employees for the entire school semester in a calendar on the Academic sheet; results return to a calendar on a Details sheet. So if someone wants to take 4 hrs personal time on 9/25 and a 4 hrs sick time on 9/25, they enter this in the calendar on the Academic sheet and results carry to a Details sheet to be: 4P, 4S in the 9/25 field. Works good and is cumulative for the semester and gives a "year-to-date" time off report.

=IF(Academic!E40<0.5,"",CONCATENATE(Academic!$B40,"",Academic!E40," ",))

I also need to use the same approach, but modified slightly to show current entries only. I'd like to add the code below to a command button on the Academic sheet with additional vba that will still consolidate entries made in the calendar on the Academic sheet, but only for the current entries not year-to-date.

Example: Employee opens file and enters time off request in the Academic calendar, employee clicks an "Update & Save" button that will consolidate entries made to the Academic calendar and save the file. Results returning B22 on Academics sheet would reflect only the current entries. When the file is closed and re-opened, the previous results should still appear on B22 and then be replaced when the Update & Save button is clicked with the newest entry.

Any help would be appreciated.

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics

  • Change military grades into rank
    Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
    Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
    Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...
  • Auto-Create a monthly Sign in sheet for preschool students
    The image below is what each page looks like. Above is space for the "Child Name" "Month" "Class" School days are obviously Monday-Friday but...
  • VBA vlookup multiple results
    Hi folks, Hopefully someone out there can help. I have a list to vlookup which works (ish). the lookup only picks up the first instance of the...
  • Extract values for earliest/latest times
    I am trying to put together a formula to get the earliest start time, the latest end time from column A for each person in Column B-F without the...