labour

  1. T

    Quantity from second worksheet

    Hi Please help, I have a worksheet entitled Sales and i have a second Sheet for a summary of sales YEARLY SALES by item. Sales worksheet SALES has 8 columns ( Invoice,date,item, Quantity, Description,Ect). In the second worksheet i would like to check a certain item in Sales worksheet and see...
  2. L

    VLOOKUP with Multiple Criteria (Checkbox and Text)

    I have the following tick boxes: "New" in Cell B18, "Used" in C18 and "Refurbished" in D18. I have a "Make" which would just be text entered i.e. "Mitsubishi", "Toyota" etc in B22. If the "New" checkbox is ticked in B18 and a Make is entered into B22, I want it to do a VLOOKUP to my...
  3. K

    It should work but it doesn't?

    Hi. I'm pretty new to VBA coding, and have been given the task of adding a warning popup box when a certain cell (merged into others so this one cell occupies the space of 6), exceeds another cell's Value (which also occupies 6 cells as 1). The first cell shows a weekly labour budget that is...
  4. B

    Plot every second cell in a dynamic chart

    Hoping I can get some help on plotting a dynamic chart from a Data Table. I'm scratching my head on trying to have only every second cell plotted to create different graphs. Here's an example of my data: <tbody> Project Cost Hours Barn 50369 Barn Labour 72563 1000 Warehouse 564892...
  5. B

    extract text and consolidate

    I have a list (A1) is Job Description, (A2) Cost items (Materials and Labour) (A3) Qty (Items and Hours) from this list I would like to extract all labour hours together with each Job Description into another work sheet. So far I have identified all "Lab" lines but where do I go to extract...

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