roll

eg if the maturity date was october 13, i'd want the maturity date to now be october 14 (monday).

Hi Guys Hope this is possible. I have a neat little single dice roll set up, but now that is working, I want to "store" the results of each roll in consecutive cells. So, dice roll 1 scores a 5 store in cell G1 dice roll 2 scores a 3 store in cell G2 dice roll 3 scores a 1...

I am writing coding for a rather large macro and I am trying to decrease the number of characters I use. One way to do this is to define a variable for the long file path name but it is not liking it. My coding is: ' Ask user for the period of the projection exercise PNumber =...

Hi, I have spread sheet and wants it to be in new order. Existing sheet Records <tbody> Roll No Name Ph1 ph2 ph3 ph4 ph5 ph6 1 abc 0300 677 748 2 def 767 87 3 hij 88 88 88 88 88 88 </tbody> New look i wants as <tbody> Roll No Name Ph 1 abc 0300 1 abc 677 1 abc 748 2...

I have a sheet called “Rent Roll”. I am looking for a simple Macro VBA code to copy the Rent Roll data sheet into a new sheet called Rent Roll Proforma. Basically I would like to have a format control button linked to a macro and when clicked, it will copy the data in the Rent Roll tab into...

Hi, I am struggling to return a result based on two criteria. A match on a Roll combined with a match on a date range to return a roll ID that was used. Please see below. I am used to using vlookup which would be simple if there were only one roll, its the addition of the dates that is...

Hi Guys, Im wondering if I could lookup partial match based on below case; let say I have value in column A row #1 in sheet A: <tbody> "Rexona Men Deodorant Roll On Ice Cool 50ml" and in the other sheet (Sheet B), I have value: <tbody> "Rexona Ice Cool Roll On 50ml" What I need is to...

I need a formula to work out number of rolls for X amount of lengths an I can' have part of a length from different roll For example if I have a roll size of 20 metes and lengths of 3 metres, for 12 lengths it is easy 12 x 3m = 36m divided by 20m rl = 2 Rolls The issue becomes when it goes up...

Hello, Im trying to get the text box to go red if the value is over 318 and green if under. This code works if I put the value directly into the code. Private Sub TextBox24_Change() If Textbox3.Text = "Cathode Mother Roll" And TextBox24.Value > "318" Then TextBox24.BackColor = RGB(255, 0, 0)...

Hello I need some help with conditional formating. Cell C has drop down for "Anode Mother Roll" and"Cathode Mother Roll" Cell P is result 1 Cell Q is result 2 In the results i need to change the cell to either green orred depending on the value inputted. If Anode Mother Roll and result is...

hi guys i have the following link https://www.dropbox.com/s/m5b64du6v5ioy0f/rollover.xlsm?dl=0 I have tried to modify the existing file but it is not working. Infact there are four menus(Collateral Unit,Documentation, Filter, Extract). When the collateral menu is selected , the sub menu...

Because I protect my sheet the spelling check doesn't work..how can I send the F7 function to open spellchecker and only check the L2 box then close? Currently the first script will opens the spellchecker, but it wants to spell check the whole document instead of just L2?? Sub...

<tbody> A B C 1 ROLL NO NAME IMAGE 2 1 AKASH 3 2 SAKHI 4 3 MAHIMA 5 4 ARJOO :nya: 6 5 SAHIL </tbody> SHEET-2 <tbody> A B C 1 ARJOO 4 IMAGE OF ARJOO 2 </tbody> I WANT TO AUTOMATICALLY INSERT IMAGE ON SHEET-2 IN C-1 FROM SHEET-1 COLUMN -C . SHEET-2, B-1 ROLL NO IS...

OK, so I have a bunch of microfilm rolls storing records of old newspapers. Each roll is numbered, but we're missing some and I'd like to determine what we're missing. Here is what my data looks like. A is the number of the microfilm roll, B is the start date of that roll, C is the end date of...

So.. I'm trying to create something in excel that can help us keep track of cutting fabric. Let's say I started out with a 500' X 72" roll of fabric. and then let's say I start to make cuts on it. So let's say I cut off 130' by 40" wide. It would leave me with 370' X 72" and then a remainder...

I stumbled across this old post http://www.mrexcel.com/tip119.shtml I messed around and found another way to roll some dice. Format A1 and B1 with any font sized 48 and D1 28. Have fun. Dice <tbody> Worksheet Formulas <tbody> Cell Formula A1 =UNICHAR(RANDBETWEEN(0,5)+9856) B1...

Hi all, I am familiar with vlookups and index match, but a new system has created a new problem that I have been unable to solve. There is an automated report that spits out the below. Column A - Roll up Column B - Location Row A - Account A complicating factor is that the numbers of...

Hello Is there a way to get excel to calculate the closest percent for dice rolls for set percentage for example if you roll 3 6 sided dice here is the percentage for each roll. 3 = 0.46% 4 = 1.38% 5 = 2.77% 6 = 4.62% 7 = 6.92% 8 = 9.72% 9 = 11.57% 10 = 12.50% 11 = 12.50% 12 = 11.57% 13 =...

For excel 2013, is there a way to setup pivot tables to roll dates. Also, is there a way to link timelines so when one date is changed on one timeline it changes all of the rest?

Hi Dear All, This is the website showing results of an employment test (http://nts.org.pk/Test&Products/Results/082017/EmoOldAgBenIst_18200817_Result/Search.php). I want to know my position in the result. So I started to search for a macro to do it and this is what I found...