schedule

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?

Hello. I'm looking for help in creating a production schedule in excel, Gantt chart style. The schedule is for Mon - Fri, 10 hour shifts. Id like the schedule to show in 1 column the routed time in units per hour to show how many units should be produced every hour, based on the total units...

Morning all, I need some help. I need to create a schedule and cannot figure out how to do it properly. Here's what I need to: Take the value of a cell (in the link below, that's cells B4 and E4) and divide it by the number of hours in the schedule (B1 and E1) and then create a number that...

Hi All, I have recorded a macro to pull data from various different spreadsheets to help determine throughput capacities. The issue I have is that one of the spreadsheets changes name daily. The line in the macro that this refers to is:- Windows("Express Schedule 5-11am.xlsm").Activate My...

<tbody> Schedule Schedule Name %1 %2 %3 %4 %5 %6 %7 1 bla1 2 0 40 6 0 8 0 100 100 2 bla2 100 100 100 100 10 3 immediate 100 100 100 100 100 100 100 </tbody> Ok.. so this is a little complicated. I currently have an If statement written that says...