Collecting Amounts Of Time For Various Tasks And Adding In Separate Page Via Menus

Dec 10, 2013

I would like to create a menu representing "tasks" where an amount of "time" can be designated per option for my employees to select and fill. I would like this information to then be tallied elsewhere so I can keep track of our efficiency.

So far, I've created a table where a "time" input is nested beside each "task" drop down menu, I would like these inputs to be added up underneath the same category on the budget tab.

For example: If I work Monday, Tuesday and Wednesday doing tiling.. I would like the budget to reflect those accumulated hours (throughout the week) nested under "tiling".

Here's the file, what I'm trying to accomplish [URL] ............

View 1 Replies


ADVERTISEMENT

$ - Extracting Amounts From One Page To Another

Jan 12, 2010

I am extracting amounts from one page to another with eg = 'Oct09'!P9,
if there nothing in that line it returns a $ -

If 'Oct09'P10, has say $10.00, then it returns $10.00.

How do I go about getting rid of the $ - and leaving it blank?

View 9 Replies View Related

Separate Spreadsheet Is Sum, By Contract, Both The Number Of Widgets Sold, As Well As The Amounts Due

Jun 16, 2009

I have a very long Excel spreadsheet (>2500 rows by approx 20 columns) that consists of >400 customer statements. At the top of each invoice, in colun B, is the text "Service Requestor Contract Number", and 5 rows down is the respective contract number. Further down (and the number of rows differ for each contract as each has its own unique level of detail) , again in column B is the text "Current Month Charges", and on the same row, in columns K and O, the current month number of items sold and $ charges respectfully. The spreadsheet is NOT paginated for each respective statement.

What I need to do on a separate spreadsheet is sum, by contract, both the number of widgets sold, as well as the amounts due.

View 9 Replies View Related

Employee Schedule Lookup Time Value And Return Name For Daily Tasks

Oct 10, 2013

I'm trying to auto input names from my schedule into dailytasks for my servers. Sometimes the amount of servers on a specific day changes(i.e Mondays 3 to 5 servers and Friday - Sunday there is 4-6 servers on) and times could change also as of now it works with

=VLOOKUP("6:00",AC$25:AJ$46,8,FALSE)

Not sure how to set up lookup value and return the name

View 4 Replies View Related

Multiplying Hours By Different Dollar Amounts Based Upon Time Worked?

Feb 16, 2012

I charge one rate for day work and one for night shifts. My spreadsheet is set to figure the total number of hours worked and I know how to multiply by dollars to get answer #1, but is it possible to use a formula to multiply times a different rate for a night shift?

For example I use =IF(B2

View 9 Replies View Related

Macro Code To Create Custom Menus & Sub Menus

Jun 9, 2008

I am using the following code to create a custom command menu.

Sub AddMenus()
Dim cMenu1 As CommandBarControl
Dim cbMainMenuBar As CommandBar
Dim iHelpMenu As Integer
Dim cbcCustomMenu As CommandBarControl
On Error Resume Next
Application.CommandBars("Worksheet Menu Bar").Controls("&New Menu").Delete
On Error Goto 0
Set cbMainMenuBar = Application.CommandBars("Worksheet Menu Bar")..........................

I want to add a new button control at the bottom of the menu underneath the holiday control but it keeps adding it on the sub menu, which leads off the holiday button control. I want the menu to look like this.

Open Net 2 Access
Add Employee
Edit Employee
Delete Employee
Holidays (3 options on sub menu)
*New Control

View 4 Replies View Related

Printing Each Spreadsheet Row On A Separate Page

Mar 29, 2007

I am trying to take a spreadsheet and have each row print on a seperate page - without having to do the print area thing on each row. Is there a way to automate this process?

View 2 Replies View Related

Numerically Sorting Columns And Copying To Separate Page

Dec 19, 2012

I am working on an excel spreadsheet that has multiple "sheets" to it. On the first sheet I have multiple columns worth of info and on the second sheet I am trying to copy some of the info from the first sheet.

For example:

Sheet 1, Column A2 has the number 1 in it.

On sheet 2 I have entered the command "=SHEET1A2" and it copies the info as I had hoped.

However, here is where my issue comes into place.

When I sort Column A on sheet 1 numerically, my answer on sheet 2 changes to whatever the new number is in box A2 on sheet 1.

Is there a way I can copy the info so that it changes as I sort the column numerically or alphabetically?

View 1 Replies View Related

Excel 2013 :: Separate Time From Date To Sort Time Frames Over Multiple Days?

Jun 17, 2014

I have a time column (A) that when looked in the cell only shows AM & PM times, but the cell itself (not showing) contains dates too, keeping me from be able to do a sheet wide sort of time or time frame occurrences.

Can I do some thing to sort these cells with their corresponding rows based on time only disregarding dates?

I am trying sort out all rows that in column (A) is time equal to or greater than 4:00 PM OR even maybe sort all rows that column (A) shows a time between 4:00 PM & 7:00 PM. The date in the cell is the problem, I think. Excel 2013

View 1 Replies View Related

Adding Time: Adding Individual Cells Works, But SUM Doesn't

Mar 28, 2008

I have a column of times: e.g. 10:03:00 and I would like to add them all up.

=A1+A2 works fine.

=sum(A1:A10) does not.

View 14 Replies View Related

Custom Menus And Sub Menus For 2007

Feb 3, 2010

From this link: [url]

there is some clever code to create a customized menu in a dynamic Add-Ins section of the Excel ribbon; this section disappears when the workbook is deactivated and re-appears when it is activated. The custom menu has 2 main items each of which can launch a macro. There is also a 3rd main item called "Next Menu" which cascades nicely to a sub-menu. That sub-menu can have several items of its own. Very cool code.

However, I am trying to add a 4th item in the main menu, say, "Next Menu2" which also cascades to a sub-menu. The problem I'm having is when I try to replicate this code to accomplish this, "Next Menu2" appears in the sub-menu of "Next Menu", rather than as a separate (4th) main item below "Next Menu".

I believe there was another post (not sure of the date, but has since expired) which asked basically the same question as mine. There was a reply with code saying "This should work" but when I tried it, it didn't help.

View 3 Replies View Related

Create Toolbar Menus & Sub Menus

Oct 4, 2007

I want to create a submenu to an already existing user defined menu.

After creating and saving the sub menu using Tools ->Customize ,it works fine. But when

I reopen the Excel sheet it is not found.

I could not find any macro related to the original User menu.Also this menu gets displayed after the AUTO OPen macro in my excel has worked. This menu gets displayed for only that workbook and not for others.

I have been trying to find out a way to create Sub menu for that ,but could not?

View 3 Replies View Related

View / Print Selected Options Contiguously Separate Page

Oct 24, 2008

I’ve created a worksheet containing many drop down lists that form an inventory of household effects. Once selected, I’d like to be able to view/print the selected options and quantities separately on one A4 page.

I don’t want the separately viewed/ printed page to contain anything other than the selected options. The problem I’m having is to arrange this new page as a contiguous list.

View 2 Replies View Related

Adding A Page To The Workbook With A Name

Dec 30, 2008

I am trying to do a macro and I want to add in a worksheet. I use the code

"Sheets ("Template") .Add"

but I keep getting an debug error. I did this in another macro but cannot find it. I need to add a specific name at the start of adding in a sheet as the sheet number increments change based on how many times you have run the macro. I know this is a silly format issue but I could not find anything in my book or searching this forum.

View 3 Replies View Related

Adding Page To Multipage Userform

Mar 30, 2013

I have a UserForm which has a multipage with 2 pages, each page has many controls and associated code. I now need to add a third page but cannot get the code supplied to work.

VB:
Sub AddNewPage() Dim NewPage As Page Set NewPage = frmColEd.mpCust.Pages.Add(, , 2) NewPage.Caption = ThisWorkbook.Sheets(2).Text frmColEd.Show End Sub

frmColEd is the name of the user form and mpCust the name of the multipage on that user form. I keep getting a 'Type Mismatch' on the SetNewPage=.... line no matter how I change it.

View 2 Replies View Related

PivotTable - Adding Page Filters

Aug 11, 2014

First, the code:

[Code] ....

My problem is with this part here:

[Code] .....

I need it to filter on anything beginning with 2613, not just 261302. Unfortunately, I do not know all the possible inclusions or I could just add them individually, so I need a wildcard to add to this filter and I have never done that.

Thus, I ask how to write a wildcard filter that will work in this pivottable.

View 1 Replies View Related

Adding Data To A Separate Worksheet

Mar 14, 2007

I have a userform which when you enter data and hit submit, inserts data into a seperate sheet in the same file. Code below

Private Sub CommandButton1_Click()
Sheets("Purchase Order").Select

UserForm1.tbJobNo.Value = _
Sheets("Purchase Order"). Range("I4")

UserForm1.tbJobTitle.Value = _
Sheets("Purchase Order").Range("K4")

UserForm1.tbOrderNo.Value = _
Sheets("Purchase Order").Range("I49")

UserForm1.cbdirector.Value = _
Sheets("Purchase Order").Range("K43")

Instead of placing the data into another worksheet i would like to put the data into a closed xls file named Purchase Order Database.xls.

How can adjust the code for it to do this?

View 5 Replies View Related

Excel 2007 :: Adding Page Break With VBA

Mar 25, 2011

I have been trying to write a macro to add a page break in Excel 2007, but I have had no success.

A friend recomended:
Columns("CC:CC").Select
ActiveWindow.SelectedSheets.Vpagebreaks.add Before:= ActiveCell

This has not had any affect when I have printed.

View 3 Replies View Related

Adding Sound When You Select A Page Of A Wook Book?

Sep 14, 2008

how would i go about adding sound when you select a page of a wook book?

View 6 Replies View Related

Adding Time More Than 24 Hours To Date Time Stamp?

May 30, 2012

I want to add hours to a date-time cell to get result in date-time.

Format of cell A1 is d/m/yy h:mm AM/PM
Format of cell A2 is General
Format of cell A3 is d/m/yy h:mm AM/PM

I want to add A2 (number of hours) to A1 to give A3.

The formula I used is A3=A1+Time(A2,0,0)

The formula works perfectly fine when A2 is less than 24, but when A2 is more than 24, the date doesn't get changed.

View 6 Replies View Related

Skip Weekends Adding Time To Date & Time

Sep 7, 2007

I need a formula to add just the time to ' date and time', ignoring weekends.

eg:

Fri 24-Aug-07 10:52 is the date and time

28:48:00 is the time

If I add the time to 'date and time', result is coming as Sat 25-Aug-07 15:40

But it should come as Mon 27-Aug-07 15:40 (hence ignoring weekend)

View 9 Replies View Related

Adding A Time Offset Based On Time Of Day

Oct 1, 2008

I am replicating a Matlab program which calculates tide levels at different times of day. I need to replicate it in excel to speed up data analysis and I am nearly there.

what happens is I need to apply a time offset to the time of high tide at port a based on the time of day, so if it is:

between 00:00 and 06:00 the high tide at port b is 81.6 minutes after the peak at port a
between 06:00 and 12:00 the high tide at port b is 74.56 minutes after the peak at port a
between 12:00 and 18:00 the high tide at port b is 81.75 minutes after the peak at port a
between 06:00 and 12:00 the high tide at port b is 79minutes after the peak at port a

I tried this formula, where CO2 has the time/date of the high tide at port a:
=IF(CO2<0.75,IF(CO2<0.5,IF(CO2<0.25,CL2+(81.6/(24*60)),CL2+(74.56/24*60)),CL2+(81.75/(24*60))),CL2+(79/(24*60)))

The problem is the high tide on 07/01/2005 07:45 is read as 38359.32 rather than 0.32 - is there any easy way to tell excel I'm only interested in the time not the date? I have this spreadsheet setup now to do all the other bits required and i is just the timing that is a problem.

View 5 Replies View Related

Collecting Data

Jun 22, 2007

What I am looking to do is pull all the data of clients with assets under $2million into another tab. How can I do this without copying and pasting? I am looking for either a macro or some kind of formula that will search the entire data dump and pull in just the clients I need without leaving any rows blank.

View 9 Replies View Related

Excel 2010 :: Adding Together Separate Currency Rows Based On Adjacent Column Value?

Dec 30, 2013

I have a spread sheet which totals the amounts in 2 columns D and E, which are pounds and pence. The formulas for each one are:

Pounds

=SUM(D3:D8)+ROUNDDOWN((SUM(E3:E8)/100),0)

Pence

=MOD(SUM(E3:E8),100)

These work very well and give me the correct figures.

What I would like to do is to add up the values of each row based on the criteria of column C and have just one value in ONE cell (as shown on lines 13 & 14), so for instance:

When added together the values of rows 3,4 & 6 are 7.25 (based on a value of "W")When added together the values of rows 7 & 8 are 5.00 (based on a value of "F")

I have tried to show this as an example in the image below:

A
B
C
D
E

[Code]....

I'm using Excel 2010 on Win 7 Pro.

View 3 Replies View Related

Collecting Data From Another Sheet.

Aug 27, 2009

It is a small program for learning new words of a foreign language.
By means of a userform one can add new words to the program which will be stored on a sheet called "data" each new data entry will get a subsequent number.

On the main-sheet "werkblad" one can by giving 2 numbers from between which to collect the data retrieve the words they want to learn.

For example. If on the mainsheet in cell B3 the number 3 will be entered and in cell C3 the number 12, only those words will be shown with a number between 3 and 12.

However sometimes I would like these words to show up in randomized order. So I made a new collumn on the "data" sheet with the following formula =rand() and sorted it, but unfortunately the formulas on the "werkblad"-sheet don't present the given numbers [3 till 12] in randomized order.

The formula I use for collecting the data from the "data"-sheet is the following:

View 8 Replies View Related

Collecting Cell Values

Dec 15, 2009

I have several sheets which give me results, e.g. "dummy1", "dummy3" and "dummy5" out of a list of all possible dummies 1 to 10. It is possible that there are any number of "dummy5" (or any other dummy) outcomes.

I just want Excel to make a list of all the possible outcomes.

In this case, I want Excel to make a List that says:
"dummy1"
"dummy3"
"dummy5"

This means Excel shall search the respective Columns and just check, is this dummy there or is it not.

View 12 Replies View Related

Inputting & Collecting Data

Dec 17, 2009

I've just been asked to do a new Quality Control project for my boss. What I'm looking to do is be able to input the thickness values of our product in one worksheet, and have it recorded in another, as well as have the data separated by the model number

The main problem I'm having is figuring out how to enter data in the 1 worksheet as a template, and have the data consecutively stored, one after the other

Are there any functions that will allow me to do this?

View 6 Replies View Related

Page Break Preview It Shows The Page Numbers In The Centre Of The Page

Jun 9, 2009

When I view a sheet under Page Break Preview, it shows the Page numbers in the centre of the Page. While I am aware that it would not print the page number I was wondering if there is an option to remove/hide the page numbers.

View 3 Replies View Related

Collecting Data In Single Cell From 2-3 Cells

Mar 16, 2014

As per attached sheet, I have the date distributed in two three cell and want to transfer data to single cell. I don't know which formula has to use to collect it together.

need solution.xlsx‎

View 2 Replies View Related

VBA - Collecting Array Of Sheets Based On Conditions

May 11, 2011

I need a code to select sheets with pages less than 15 to print out. Also, a code to print out just the first 5 and last 5 pages if its more than 15 pages.

I've tried this so far but no success:

For X = 1 To Worksheets.Count

If Y Is Nothing Then
Set Y = Sheets(X)
Else
If ExecuteExcel4Macro("Get.Document(50)") < 10 Then
Set Y = Union(Y, Sheets(X))

End If
End If

Next X
Y.Select

View 6 Replies View Related







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