spare

  1. D

    Excel - Getting a Roster to highlight/identify gaps in a 24/7 roster

    I have looked through some of the other questions on here and can't seem to find the answer so hope someone can help me, there is probably a simple fix to my issue and I am showing my limited knowledge regarding the functionality of excel. I have a 24/7 roster that I would like to automatically...
  2. R

    VBA to insert text

    Hi all I would like a word to be inserted into a cell if it is blank. Example: If A1 has any value in it and it is deleted and A1 is blank, the word "Spare" will appear. Thank you!
  3. R

    Calculate spare matches

    <tbody> 1 2 3 4 5 6 7 8 9 10 X 9 \ X X X 9 \ 8 \ 9 \ X 9 \ X 20 40 70 99 119 137 156 176 196 216 "10" "10" "6 10" "4" "10" </tbody> Line 1: Is lane numbers Line 2: Is what was bowled in each frame Line 3: Is the score attained in each frame Line 4: Is the spare...
  4. S

    Compile different column data

    Hi All, We are collecting spare sale information using Microsoft, data is getting accumulated as Spare code 1 – Spare code 1 Qty , Spare code 2 – Spare code 2 Qty , Spare code 3 – Spare code 3 Qty , Spare code 4 – Spare code 4 Qty . Now we want to compile the file as ASC name , spares list...
  5. Z

    Find a cell that matches a pattern and return that cell's value with an incremented numerical value to the Active Cell

    I am trying to search for the first cell above my active cell (just in the same column) that contains the words BOX or SPARE. The words BOX and SPARE will also be followed by an integer value that's up to 3 digits long (e.g., SPARE 22 or BOX 81). I'm trying to find the first cell that contains...
  6. Z

    AutoFill to every 3rd row

    My work uses spreadsheets to display the current inventory for companies we rent to. The way they have it formatted is, starting in A56, they'll have "Box 1", in A57 they'll have the serial number of the equipment, and then A58 will be blank. A59 will be Box 2, A60 will be that serial number...
  7. F

    VBA to load data from userform to next available row

    problem - require vba when commandbutton click in userform1 goto sheet "log" for spare row textbox1.text to be pasted to column A textbox2.text to be pasted to column B textbox3.text to be copied to column c next time userform loaded and command button clicked next spare row same as above...
  8. M

    subtract remaining number from different cell and 'remember' it

    Hello guys, Trying to subtract a number from a cell until it reaches 0, then subtract the remaining from a different cell and keep that number for the next time. A1 has a value of 50, that is the spare amount A2 has a value of 30, that is the total amount then in B2 I have a value of 10 b3...
  9. M

    Add background colour to ListBox item(s) that have been selected...

    Hi Team, I have a UserForm ListBox that is populated via a SQL connection. When a value is selected, a delimited string containing the selected values is created in a cell on a spare worksheet. I would like the background colour of the ListBox item to be a different colour if it exists within...
  10. C

    Averaging cells in multiple worksheets

    I am creating a report with 75 different survey results and I am trying to find the averages of each of the answers. I am working on the formula and I keep getting errors. Here is what I have (I'll spare you all 75 and only input 10)...
  11. M

    Excel model to affect Outbound Capacity Constraints

    Hi all, Happy bank holiday from the UK. I'm trying to create an Excel model which tracks my outbound capacity from a warehouse and identifies where the capacity is forecast to be exceeded, and adjusts the outbound volume to the weeks where there is spare capacity. <tbody> At the moment I...
  12. 5

    Calculating the importance of which car spare parts should be expedited based on lead time

    Hi all, Imagine you run a fleet of thousands of vehicles. You have a few hundred which are not usable because they are waiting for one or more spare parts. You keep track of all the spare parts ETA to your workshop. I'm struggling to make a formula which would rank the whole list of spare parts...

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