calendar automation

Hi All, I have a list of events that I want to be pulled into a calendar so it can be displayed easily. The calendar is just a generic Excel template. Is there a formula that will be able to pull the info from the table and place it into the correct dates on the calendar? The calendar...

Hello again wonderful people. I have a partially automated calendar Excel file I track my time off hours in for work. I've been upgrading it a little at a time, as I learn new functionality and I've gotten to a point that seems to be very close, but is stumping me. I've extracted the relevant...

Hello, If someone could help me, it can be vba or just formula in excel. My dilema is to make a scheduling calendar that tracks the frequency of lab test. For example, normally test should be done every three days, which will be recorded in the calendar. However, if for 20 days, the tests seems...

I need a formula or macro I enter a “start date” say 1/5/2022 use count +28 in a different cell I get 2/2/2022 use count +14 and get 2/16/2022 then repeat in the pattern of +28 / +14 this is how I got my work schedule for the year ( I’m a sailor )…I need to pull days worked per pay period...

Hello, all. I'm looking for some help on a thing I am working on. On sheet named "status" -which is also the database, you can see columns of information. Basically, what I need help with is I want the data to appear on the calendar I created on "Main Tab" in 1 condition: it is "Approved" as...

Hi everyone, I am preparing a calendar that takes information from a event list. Now, I can show events on this calendar by city, date and name. The problems are 1-) If a event has 2 or more days, it is showed on calendar separately. (Like 3 days-event has it's name in every one of B3-B4-B5)...

Hello! I hoped it would not be necessary to make a separate thread about my "problem", but I can't find an answer. I am currently working on a monthly shift calendar that keeps track of how many hours an employee has completed/month, the holiday dates each one reserved for the past, current and...

I am trying to develop a macro in VBA to manage loaner vehicles for an automotive service department (see sample below). This is what I have put together so far, obviously it doesn't work: Sub Duplicate_Entries_Based_on_Return_Date() Dim lastrow As Long 'Find the Last Row...

Hi All, I’d much appreciate your guidance on how to create acalendar which would auto-populate activities per day based on conditions. I’ve done some Googling but cannot find exactly what I’mafter 1, I’d use one of the Excel Calendar Templates which updatesdates automatically based on...

Hi, I want an easy way to access daily reports using a calendar as a dashboard. I have already created the calendar in Excel which runs from 2018 and 5 further years to future proof the document. On a separate tab I have created the Hyperlinks for every daily report for the next 5 years so that...

New here! But I need some help automating data within an excel sheet. The attached sheet contains 5 tabs. First tab is a tracking sheet, second tab is a US calendar, third tab is a CA calendar, fourth tab is an AU calendar and the final tab is a list sheet for reference. Using the tracking...

Hi, I've been trying to create a macro that blocks transportation time automatically when I have an event with a specific name. More precisely, I want outlook to book one hour to transportation right after all events called "S afleverer" (danish for S brings the kid to kindergarden).

Dear all, I have a excel file with some deadlines and tasks. What i'm looking for is a vba code or formula to alert me which task is available for the day, when i arrive to the office. Also, I'm trying to, in some tasks, send a email with the fields "To", "Cc", "Subject" and "Text/message body"...

Hi guys, I have a question that has been on brain for the last couple of hours.... I am working on an attendance tracker and each month of the year has its own sheet in the same workbook. Then I have an overall sheet. On the overall sheet I would like a column for to find out how many points...

I am trying to take a list of dates (specifically birthdays, anniversaries, etc.), and import them into my Outlook Calendar. I have seen a couple of articles and YouTube videos on this, but I can't get it to work. Using 2010 on both. Does anyone have a sure fire way to do this?

I've been trying to figure out if it is possible, which I'm sure it is, if I can check a date against mulitple ranges of dates to see if it falls between any of them. What I'm ultimately trying to do is have a list of reserved spans of dates then on another worksheet have a dynamic calendar...

Hey, so I'm trying to create an excel file where engineers would input information about an upcoming job, then have it auto-populate the calendars per the days of the job and of each stage in the job. I got the rolling calendar running for the quarterly and monthly and weekly view, figured out...

I have a spreadsheet that is meant to track the sales, variance, and labor each day and calculate this percentage as a month. I would like to create a button that will navigate through the months of the year, displaying each day with the data intact. [/URL][/IMG] As seen in the picture, each day...

Hi, I have column A = all 2015 calendar, from columns E to Y are the number of students in each place each day. Column AB is the total of students each month on each place to calculate the total gain. I set the formula =SUM(E3:E33) to give me the total number of students of Place 1 in January...

Hello, I am using Excel to create a calendar and I am using the formula to highlight all cells between date. <tbody> =AND(R$22>=$I23,R$22<=$J23) </tbody> Where R22 is the first date of my calendar which is going by weeks and I23 & J23 are dates. EG. R22 is 1st jan and I23 & J23 are...