Break board Tool

DELL_Roy

New Member
Joined
Dec 12, 2016
Messages
3
Hi All,

First of all I want to say thank you. I've just registered today but your forum has being a big help so far!
I hope you want to help me with the following as I really don't know where to start..

I'm creating a sort of Break board tool where I need my colleagues to give certain breaks.

I've managed to create this but right now I want to check whether they already had a morning break or lunch or afternoon break.

-
My sheet is build up like this:

Sheet: Cover. Adds the break and shows who has a break etc.
When you add a break it will be added to the ''database'' as well.

Cell: B2 - Team Name
Cell: B3 - Persons Name
Cell: B4 - Type of break (Select: morning, lunch & afternoon)

Right now I'm stuck at this point.

The database is build up like this:

Column A: Name of the person
Column B: Date of today
Column C: Morning break (0 is none 1 is already had a break)
Column D: Lunch (0 is none 1 is already had a break)
Column E: Afternoon (0 is none 1 is already had a break)

So what I would like to do is when you add a break (Persons Name) add it to the database but if the personal already had a morning break it needs to tell me ''Person .... already had a morning break".

I hope this is clear enough. And I hope you are willing to help me!

Help is much appreciated.
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
Welcome to MrExcel,

Are you wanting a VBA solution and, if so, do you know how to paste VBA code into a workbook then make a button to run the macro?

Do you want a drop down list for B4 - Type of Break? Do you know how to use Data Validation to make such a drop down?
 
Upvote 0
Welcome to MrExcel,

Are you wanting a VBA solution and, if so, do you know how to paste VBA code into a workbook then make a button to run the macro?

Do you want a drop down list for B4 - Type of Break? Do you know how to use Data Validation to make such a drop down?

Thank you!

I've managed to create the code and it's working now. I'm wondering if there is like a quicker way to do this..

Code:
If breaktype = "Morning" Then
Sheets("Checksum").Select
Dim cell As Range
For Each cell In Rng
If cell.Value = agentname Then

cell.EntireRow.Select

End If
Next
For Each cell In Selection
If cell.Value = "1" Then
MsgBox ("Agent already had a morning break.")
Sheets("Cover").Select
Call Refresh
Exit Sub
End If
Next cell
Call AddBreak
Sheets("Cover").Select
End If
 
Upvote 0
I'm a bit struggling right now..

I hope someone can help me out. I was using a pivot table but as I wanted to have this document to be a shared workbook it's not possible to update the pivot.

I've build up my sheet with a DB sheet (data will be added there per day)

Build up like:
Column A: Name of person
Column B: Break Type
Column C: Start Time
Column D: Team Name
Column E: Date
Column F: Convert date to: "MM/DD/YYYY"
Column G: Morning Break (1 is break, 0 no break yet)
Column H: Lunch Break (2 is break, 0 no break yet)
Column I: Afternoon Break (3 is break, 0 no break yet)

I need to convert this to another sheet where all the person's names are in a big list and the day of today.
There I need to add if the agent had a morning break (1), Lunch(2), Afternoon(3).

Now I've tried this with the IF(Vlookup statement and this worked.

=IFERROR(IF(VLOOKUP(A2,DB!A:I,7,FALSE)=1,1,0),0)
LOOKUP (Agent Name = Equal to, Column 7 = Morning break (if 1 then show 1).

But it doesn't select on the date in the database sheet as there are multiple dates in...

Is there a quick way to select on the date as well?

Is there a quick way to do this?
 
Upvote 0

Forum statistics

Threads
1,213,567
Messages
6,114,342
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top