help is needed

  1. E

    Search bar that searches through multiple columns in another worksheet

    I have a large inventory database (almost 8,000 rows by 38 columns) generated by querying many different spreadsheets. The queries are merged into one giant table that I would like to search from. Each row contains many columns of information about the piece of equipment that someone might...
  2. A

    Alternating row shading macro

    I am trying to create a macro to alternate row colours in a selected range. Currently using conditional formatting and this is what the code looks like right now Sub Row_Shadding() ' ' Row_Shadding Macro ' ' Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _...
  3. S

    formula help

    Hi All, I've been playing about with try to work out a way of finding when the next promotion is due on this sheet, so far all I've seemed to do is make things more complex on the sheet, is there a easy way of find out when someone due there next promotion. I've included the sheet below...
  4. S

    Excel Addition Question

    When I have WBT triggered in column C and there is an X in column E, I want the total of column D in each row WBT is triggered to appear in Cell B45. Example: WBT is noted in C4, C5 and C8. There is an X in E4, E5 and E8. I need to add up D4, D5 and D8 and have that total placed in B45. Does...

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