spare

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...

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!

<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...

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...

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...

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...

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...

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...

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...

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)...

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...

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...