schedule

I am trying to create a tracking system for the data below. The macro will run in the first tab and track the data from the second tab. I need the macro to match the sections then look up the date from the first tab and determine which date range it falls into on the second tab. Once it has...

I have a worksheet that lists a baseball schedule. I'm trying to find a way where I can enter W or L (win/loss) in a column on the schedule and it will update another worksheet with the total W/L record. Ultimately I would like to have a pivot table that sorts the records from first place to...

Hey there! So...my boss creates these very confusing and messy schedules. I would like to make a auto-populated streamlined version of his schedule. Here is a link to my worksheet (its just a dummy containing no personal information)...

Hello there !!!! I am new to excel and trying to do a pretty big project and I cannot figure out how to solve an error that keeps popping up. I have a weekly schedule which has 7 columns, each one for a day of the week. I am now trying to do a daily schedule which copies all the values from the...

All - I've checked previous threads on this topic and havent found what I'm looking for. In my VBA I am downloading data from the first sheet on a Google Sheet workbook. This has not been a problem. I am using this code... ' Download Production Schedule as csv...

Hello, I've been trying to create an excel daily schedule that archives the days that I put in according to their date. I want to be able to type in a certain date and have the sheet show the plan for that specific date. I'm okay with using VBA, any ideas? Thanks. (New to this forum, by the way)

Hey everyone, I have 1 month worth of schedule for work in Excel and I want to make it easy for everyone to read it when the file opens up. So basically, I want to keep the current week's schedule and gray out with transparency the week before and the week after the current week. I want it to...

I've been looking at a few different ways of doing this, hoping someone could possibly shed some light on what may be the easiest way. I'm trying to build a schedule for my offices equipment that goes out into the field (We have about 70 or so pieces of gear to log). Gear to be listed down the...

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...

Is there a way to convert this schedule into a two column schedule <colgroup><col><col><col span="14"></colgroup><tbody> 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 13 12 6 15 8 3 10 5 11 7 9 2 1 16 4 14 9 16 8 14 15 10 11 3 5 2 7 13 4 12 1 6 </tbody> <colgroup><col...

Hello All, I have a Transmittal column on a Drawing Schedule worksheet that I want to auto populate whenever users add transmittal data (This is being done by VBA Already and is working fine) to another sheet that is the Transmittal Log. some things to be aware of, this vlookup has to meet...

Does anyone have a simple excel tool to calculate schedule performance based on the number of days in a project, hours estimated and actual hours to date to show if a project is tracking to schedule, ahead or behind?

Good afternoon! I have a table that is used for a schedule with several columns: Role, Name, Service, D1, D2, D3, etc. In the Day columns (D1, D2, etc.) the cells have data validation to show a list of possible codes. The end user will fill out the schedule and once completed print the...

I have a form titled "frmHomePage" which holds three subforms. ""frmReportsSubForm", frmStudentSchedule", and frmStudentBio". When I enter a new student in the "...Bio" subform I would like to go directly to the same student in the "...Schedule" subform. To this end I have a button which hold a...

Hi All, Happy belated new years greetings to you all. I need your help on my query. I have 2 spreadsheets. Spreadsheet 1 is the main register and Spreadsheet 2 is a schedule. Linking all required details from S1 to S2 is ok using VLOOKUP function except for the last part of the schedule...

https://imgur.com/MW70EzR NOTE: So far, I only have conditional formatting for an X in this sheet and the positions of the "x's" is not valid right now. Please ignore them :) NOTE: Schedule Range E12:BE47 Okay, so what I'm trying to do, is build an afternoon schedule for some of our...

I'm attempting to create a button that when pressed will copy the current sheet to the end of the sheet list and rename it using some predefined text as well as incremented data from one cell. The cell is A1 and will contain a year. I want to have the new tab be renamed to 'Schedule 2019' when...

Hi all! I am not really sure what to call what I am looking for, so if this has been asked before I apologize. I am making a schedule each month and I want to make sure I dont schedule people in more than one department. Is there a function that will allow me to type in a name on one sheet and...

https://templates.office.com/en-us/Daily-work-schedule-TM02780252hi Hi all, Happy Anniversary to Mr. Excel. I've downloaded the Daily Schedule (Re link above). It's really great tool however the EVENTS doesn't appear in the schedule and I don't know why. It downloads as an excel template...

We have a schedule that about 7 people access. When a user opens the workbook it keeps defaulting to a tab that was the work schedule from several weeks earlier. I would like it to default to opening in the current weekly schedule. Or just open in the last used / saved tab?