Scanning Schedule

Dec 2, 2006

The table posted above is the schedule for my employee. I need an input box which asks for a date. When the user supplies date, it should look for people who are scheduled for that particular date and who are on leave and put the result in the next worksheet at the last occupied row.

For instance, if I supply the date as 2nd Dec then the next worksheet should be filled with @ row # 2 (Row1 has headings)

EmployeeEmp IDSchedule
A123409:00 PM - 06:00 AM
B123511:30 PM - 08:30 AM
C123602:30 AM - 11:30 AM
E123811:30 PM - 08:30 AM
G124009:00 PM - 06:00 AM

Then if I select 3rd Dec, the next worksheet should be filled with the following data starting fom row number 7 (just below the above data)
A123409:00 PM - 06:00 AM
B123511:30 PM - 08:30 AM
D123705:30 AM - 03:00 PM
G124009:00 PM - 06:00 AM

View 9 Replies


ADVERTISEMENT

Scanning Barcodes Into Excel - Macros

Sep 5, 2013

I am working for a small job shop company that is producing many bespoke products and recently the company has grown up a bit and a shop floor data collection is required in order to have a control over the production process. The company has 14 machines which are operated by 7 operators and this means that each operator is running 2-3 machines at the same time. The best solution for data collection is barcoding into excel. However i need 3 macros (I think) in order to meet my needs. Those macros need to:

1) show what is currently on the machines (who is doing what and when the particular job has started)
Machine
Operator
Part No
Description
Clock In

Note: Description will not be scanned, this can be filled in based on the vlookup from the waiting parts list

2)show what have been done (who did what, on which machine and clock in/out times). Here it is important to mention that sometimes jobs are stopped and taken off the machine and they are put on the machine later on. Sometimes it will be different machine or operator etc)

Part No
Description
Machine
Operator
Clock In
Clock Out
Machine
Operator
Clock In
Clock Out
Machine
Operator
Clock In
Clock Out

3)show what is remaining to machine.

While searching for a solution I have found here a really nice topic which seems to be a good foundation for my needs Scan barcode to excel with date & time stamp in & out.

View 1 Replies View Related

Scanning Range Instead Of Single Cell

Aug 5, 2006

I am trying to make this macro look at multiple cells in column X and perform the given operation based on what is found. I currently have it set to look at one cell, I am not sure how to make it look at a range of cells and change its cell refrences for the copy function.

Dim vS As Variant
vS = Sheets(3).Range("X5")
If Not IsNumeric(vS) Then
Exit Sub
Else
Select Case vS
Case 1
If MsgBox("Are you sure you want to delete?", _
vbYesNo, "ExcelTips") = vbYes Then
Application.DisplayAlerts = False
Sheets("Approved").Select
Range("B5:F5").Select
Selection.Copy

View 9 Replies View Related

VBA To Lookup Part Number When Scanning A Barcode

Feb 14, 2014

I have a USB scanner connected to a PC. Data is entered into Excel when the part number barcode on a box is scanned. I have two worksheets that I will be scanning part numbers into, one is Group A and the other is Group B. On Group A's sheet there is a list of Group B part numbers that will be used for the lookup procedure when the barcode is scanned. The same is true for Group B's sheet. The groups should never be mixed, so if part number "B005" is scanned into Group A's sheet it should cause an error message to pop up. I've attached a workbook as an example. Is it possible to do this with VBA?

Barcode Scan Lookup.xlsx

View 3 Replies View Related

Reset The Schedule..

Jan 15, 2009

Is there a way to take the values between C2 & D2 and have them automatically post in column F ?

View 2 Replies View Related

Schedule, Organizing

Oct 15, 2008

I make our employee schedule at work, and so in Excel I have eight sheets for one workbook. (Employee schedule, then each day of the week) On each day is a table separating the shifts. Morning, Split and Night.

I was wondering if there was a way for Excel to look at the schedule sheet, and then automatically place each employee and their shift on the following day sheets. (example: Joe has 2-10 on Monday, 10-6 on Thursday and Friday) So the Excel puts Joe underneath Split 2-10 for Monday, and Morning 10-6 on Thursday and Friday.

View 10 Replies View Related

Schedule A Macro To Run

Nov 15, 2008

I am trying to schedule a macro to run at 11:45 pm every time. I use system scheduler to open the excel file and when I use this command to run the macro nothing happens. The workbook opens fine but the macro does not run. I only wants to run the macro once day even if I open the workbook during the day I do not want it to run.

View 13 Replies View Related

Schedule Template

Oct 16, 2009

We have huge restrictions on hours, and to avoid inputting, then revising the schedule into my companies scheduling module, then having to change it again when the boss looks it over, it's just confusing.

Anyway, I'll get to the point, I want to add the hours up in a row of cells for the week sunday through saturday. Like so:

1100-2100 | 1100-2100 | OFF | 1100-2100 etc... I want it to add these cells hours up and have the total end up in the 8th cell.

Is this possible? I am a new excel user, or at least, setting up my own sheet.

View 10 Replies View Related

How To Write A Schedule

Feb 9, 2007

Excel is a new program for me sorry to say it but i have been try to figure out how to write a schedule on it and tally the hours for each employee i have them set up in rows right now and i hope i can keep it that way but i am tired of add hours up for each employee every week i'm sure it is really easy but can some one let me in no the little secret

View 9 Replies View Related

Weekly Schedule

Feb 24, 2009

Have a basic weekly schedule for 300 employees. Need to be able to identify the last day off in previous week so the following week isn't scheduled to work on the 6th or 7th day without a day off. For example, if schedule is Mon - Sun and employee #1 has Mon & Tues off this week, next week Mon would be the 6th day so I wouldn't schedule that person on Monday the following week. Calculate last column "Next Wk Mon" instead of manually figuring it out... Need to be able to identify last day off, count the days from that point to the next monday. It becomes difficult when days off are split...

MonTueWedThuFriSatSunNext Wk
23-Feb24-Feb25-Feb26-Feb27-Feb28-Feb1-MarMon
Emp 1OffOff6
Emp 2OffOff5
Emp 3OffOff4
Emp 4OffOff3
Emp 5OffOff2
Emp 6OffOff1
Emp 7OffOff1
Emp 8OffOff4
Emp 9OffOff2

View 9 Replies View Related

Schedule Tasks ..

Apr 6, 2009

Im having trouble with getting a macro to run at a specific time and day (Every Thursday at 7PM).

Here's what I have done so far..

1. I added my excel file to the task scheduler
2. created a class module and place the code below into it.

In testing the workbook opened but it asked if i wanted to enable or disable the macros - how do I get around this? And it does seem to kick off the macro (create_all).

Private Sub Workbook_Open()
If Hour(Now) = 1130 And Weekday(Now, vbMonday) < 7 Then
' TheNameOfYourCurrentProcedureHere
create_all
If Workbooks.Count = 1 Then
Me.Save
Application.Quit
Else
Me.Close True 'save the changes and close the workbook
End If
End If
End Sub

View 9 Replies View Related

Creating A Schedule

Jun 12, 2009

I am Cuttently creating a schedule in excel for work. the schedule will look like this:

Name.........................Shift
Andrew.......................6-3
Jonathon....................12-7
Kim............................9-5

etc etc

the thing is though this is simple enough but i am trying to use a bar chart to help me show how many people i will have on shift at anytime e.g ...

View 9 Replies View Related

Creating A Schedule ..

Aug 27, 2009

which is row D on my excel sheet. I need to fill into another form who works shift D, shift E and shift N. Is there a formula I can use to do this? I have given a small sample of my schedule below.

AB CD 252627ShaunD DDNicoleD EDEmilyE DECathyENEJohnNEN

View 9 Replies View Related

Delivery Schedule Percentage

Jun 26, 2014

run a spreadsheet for Vendor Deliveries and got as far as promised delivery date and actual delivery date with a late or on time comment. Im trying to get a percentage from this data.the excel spreadsheet that i have uploaded.Delivery Schedule.xls

View 5 Replies View Related

Work Schedule Formula Using IF?

Jan 8, 2014

Combing these two formulas. I have a work schedule spreadsheet. If the employee is Off I want the value to = 0 (zero hours). But if the cell has a start time I need it to calculate those hours. I know both of the formulas work individually. But I need them to work together.

Formula for when cell says OFF:
=IF(C11="Off",0)

And the second

Formula to calculate hours (based on start time/finish time is the same for all employees)
=($X$4-C11+($X$4<C11))*24

View 2 Replies View Related

Maintenance Schedule Checklist

Mar 2, 2009

I am trying setup a maintenance schedule checklist for a large list of items. Each item has a cycle in weeks for the checklist. I set up a nested if statement to check if the item is overdue or done based on the cycle and the current date. The if statement checks when the last time the item was done or overdue and populates an "X" for the next due date. It works fine as long as the cycle is 4 or less. After that there are too many if statements and I get an error. I'd rather not have to use a macro to get this to work. Any ideas?

View 14 Replies View Related

Networkdays In Production Schedule

Jul 2, 2009

I have attahced an example of what I need to do. I need to project due dates for each of our 8 departments based on a ship date of the final product. Each of the 8 dept. have a number of operations (ops) and given number of hours for each op. These alocated hours change on every job plus I have 2 outside operations that may or maynot be added to the mix. I don't have a clue on where to even start with this formula.

View 2 Replies View Related

Time Sheet Schedule

Nov 21, 2009

I need to do is calculate the hours between two clock times minus 30 minutes.

Example:
Cell A1 - 4:00am
Cell B1 - 16:30
I need Cell C1 to say 12 (hours)

Also:

Cell A2 - 17:30
Cell B2 - 02:00am
I need cell c2 to say 8 (hours)

View 6 Replies View Related

Work Schedule Timesheet

Dec 19, 2009

I have made a work schedule for my local business and have set up a series of formulas that will fill out time cards that I could print out directly onto the paper time cards. The formulas that I have work except that if there are two subsequent entries that later will not return a value and result in an error.

If you could take a look at it that would be awesome. To use it you just need to type a name into the name column and a work time into the time column for that day. then in the other sheets( one for each worker ) it will set up the time card. The the error happens on Thursday, when Bob has an entry right after Fred. Then on Bobs sheet it gives me a #N/A.

View 10 Replies View Related

Accounting Prepayment Schedule

Jan 28, 2010

I'm trying to automate the calculation of my prepayment schedule. The linked image http://img402.imageshack.us/img402/2...mentqueryp.jpg shows the basic layout of how it will look. The yellow cells are going to be the only input cells but i'm unsure what formula will achieve the desired result i'm looking for across the remainder of the spreadsheet. Essentially I need the formula to look at the period (start and end dates) the invoice covers and apportion it correctly. The apportionment isn't a straight equal division per month though as it has to be calculated according to what element of the expenditure hasn't been realised yet.

For example in the car park rent line the figure of £8,000 in July is derived from the fact that that is how much hasn't effectively been incurred yet as it relates to the remainder of the invoiced period (Aug - Mar) and is calculated as 8/12 x £12000.

I hope you understand what i'm requesting, if not, let me know and i'll try to provide a better explanation.

View 7 Replies View Related

Model For Payment Schedule

Aug 20, 2013

I'm currently developing a model for a payment schedule. For example, lets say a customer purchases an item from a store, but the store receives that payment in the following month. I'm looking to develop a dynamic model so that if I change the assumption from 1 month to another term (2,3,4+ months etc.) the model will adjust accordingly.

I've started with a formula

=IF(MONTH(H3)-MONTH(G3)=B14,G11*B13)

But of course this will not work once the term is set to larger than 1 month. With B14 representing 1 month, and G11*B13 being payment information (price * quantity).

View 2 Replies View Related

Trying To Build Automated Schedule?

Jun 23, 2014

I have been trying to create a macro that would create a schedule for me based on date and a product type. In columns K-N I have an IF statement that tells when a shipment would need to arrive in a row that corresponds with a date (column A is 1/1/2015 - 12/31/2015). On the next page I would like to generate a schedule that lists the dates that all of the products are needed in chronological order. I've tried to use custom functions like finding the nth_occurence but it just gets way too messy with so many shipments.

View 6 Replies View Related

M-F Rotating Schedule With 7 Employees

Dec 9, 2013

After much searching today I've been unable to find a way to do this. All my searches resulted in some generic looking site looking to sell me some scheduling software.

I have a team of 7 people and I need one person to work a late shift each day of the business week. M-F

I would like a way to have the schedule automatically advance to the next person.

View 1 Replies View Related

Schedule The Hours Are Different Than The Numerical Value

Apr 12, 2007

I have an excel document and I don't know which formulas to use. Here is how the document is laid out, it's an employee schedule.

The row includes A: Name B: Sunday C: Monday ... J: Total

Columns below include the employee names. What I am doing is filling out the employee schedule and I need excel to calculate scheduled hours. My problem is, when I make the schedule the hours are different than the numerical value given by excel. For example, Sunday I have an employee scheduled from 8-4. That's 8 AM until 4 PM; or a total time of 8 hours. Excel would read that as 8 (minus) 4, rendering the results useless. Once I figure out how to calculate hours by such input, I'll need to make totals which won't be as difficult.

Also, if there is a way to set the value of the word "Close" to 12:15 AM that would be extremely beneficial as well.

View 9 Replies View Related

Weekly Employee Schedule

Sep 16, 2008

I'm trying to create a weekly employee schedule using Excel 2007 and have several issues but will start with one at a time till we get them all resolved.

I put in my start hour '6' in cell 'B7' and get this: 1/5/1900 12:00:00 AM.

I would like for to display 6AM.

I figure if I get his cell fomatted that I can get the other times correct then go on to the next issue.

View 10 Replies View Related

Tab On The Sheet That Looks Up Name And Compares Against A Schedule

Nov 26, 2009

I am currently trying to take a list of people who have log in times at work however if they log out then back in the result is what you see below.

What I am looking to do is match the find the name then find the earliest time (login Column C) and then the last or latest time (log out Column D)

A B C D
John Smith64676076:02 AM6:13 AM
John Smith64676077:25 AM11:27 AM
John Smith64676212:08 PM4:01 PM
John Smith64676076:13 AM7:25 AM

Would like a formula as I have another Tab on the sheet that looks up name and compares against a schedule to see if the person was late or left early.

View 9 Replies View Related

Validating Times In A Schedule

May 2, 2007

I have been trying to achieve the following with formulas but have not been successful. I am making a simple schedule, and I am trying to validate the cells so that you can not schedule someone for multiple tasks during the same time range. In the example that I attached, Harry is diswashing from 1:00 - 4:00 but is also scheduled to paint from 2:00 - 5:00 (this should not be allowed). How can I achieve this with code?

View 7 Replies View Related

Seeking Min And Max Times For Work Schedule

May 31, 2013

I am trying to extract times from a work schedule to automatically generate a 'time in' / 'time out' chart. Been trying to use the lookup formula amongst others with little success.

See example template attached...Example Sheet.xlsx

View 9 Replies View Related

Using OnTime Schedule To Set Or Reset A Cell Value

Jul 24, 2013

I just can't seem to get the syntax correct for setting or resetting a cell value using the OnTime schedule function. It looks like the cell value changes randomly and after several cycles it just runs non-stop very, very quickly and I have to use the ESC key to break out of the loop.

Here is my code:

VB:

Sub RunOnTime()
dTime = Now + TimeValue("00:00:10")
Application.OnTime dTime, "RunOnTime"
If Cells(1, 4).Value <= Cells(6, 2).Value Then
Cells(1, 4).Value = Cells(1, 4).Value + 1

[Code]...

View 1 Replies View Related

Automatically Shade Cell On Schedule?

Jun 27, 2013

I have put together a duration schedule for work and have it set up now so the days with automatically fill if they are on or between the start/end date. Below is the formula that I have constructed. As of right now each activity is colored the same. I would like to have each activity match the color of the person performing it. My crew names are all in column A with a conditional format to be color coded with the name entered.

View 11 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved