subcontractor

  1. A

    Swapping Named Cell Ranges Using Drop Down List

    I have searched all through google and cannot seem to find vba code to get me to what Im trying to accomplish. I have named the following groups of columns by going to Fomulas, then Define Name. Columns V:AB are named "Position_1" Columns AC:AI are named as "Position_2" Columns AJ:AP are named...
  2. S

    Help me! Pivot Table Failures...

    Good day Mr. Excel community, I'm hoping you can help me reorganize my data to suit my needs. Here's what I have... A list of subcontractors (Column B) with the bid package they have been invited to (Column A). I've pasted a small portion of this list below, but it includes over 400...
  3. P

    Sumproduct help

    Hi All, hoping someone can help me out again? I have a small table of rates that i can use INDEX or SUMPRODUCT to find a specific rate based on the role and subcontractor. I have another column of hours that i would like to use this rate on. Next to the hours column is another column that...
  4. B

    Help needed adding the last bit to a formula

    hi All, wondering if someone could help me out in figuring out the last part (I hope) to a formula. I have the below formula which returns the correct information however I would like it to add a figure to the end of the text. this formula =IF(W2="(Subcontractor)",K2& " (Subcontractor)")...
  5. B

    Help needed adding the last bit to a formula

    hi All, wondering if someone could help me out in figuring out the last part (I hope) to a formula. I have the below formula which returns the correct information however I would like it to add a figure to the end of the text. this formula =IF(W2="(Subcontractor)",K2& " (Subcontractor)")...

Some videos you may like

This Week's Hot Topics

  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • Highlight Row and Column on cell selection
    In the following I have some code I need modified to see if I can do the following: 1) Only have this work when selecting a cell inside a couple...
  • Need Numbers Inputted and Deleted
    Thanks for your help. Not sure if there is even an = equation for this. Please see attachment. If there is a solution, please respond with = So...
  • Worksheets(x).Select Error
    Hi, I am trying to select multiple sheets using the following code. [CODE=vba] Dim x As Integer ThisWorkbook.Worksheets(3).Select...
  • myFind Range not working
    Please can someone say why this myFindRng goes red in the code? [CODE=vba]Private Sub Model_Chose_Change() With ThisWorkbook.Worksheets("Job...
  • How to identify the last page break in a sheet
    How can I find the position of the last page break in my sheet? There may be multiple pages and I want to know how to find the position of the...

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
Top