generated

So A2 contains ID number 140686001 I want the next number in the sequence 140686002 to be generated in A3 only if B3 contains text How do I do this?

Using Excel 2000 Hi, I want VBA the could generate "set of 14" out of "3-digits" My 3-digit set is in the A2:A4 consists of "1X2" In the cells A6:A45 filled number 1 to 40 this mean I need 40 random sets or it can be asked via input "how many set required" First "set of 14" is...

I'd like to make a list of 16 numbers randomly generated from anywhere between 1 and the largest number found in column A. I'm currently doing that in the range B3:B18 ... currently using the formula ... =RANDBETWEEN(1,MAX($A:$A)) However, I'd like the randomly generated list to have unique...

I have a list of 500 dates in one column. all of them are US locale. Then, I used the custom format mm-dd-jjjj;@ (I am in the Netherlands, hence the J instead of Y) Strangely enough, some cells show then as dd-mm-jjjj, and when I then choose that format, they change into mm-dd-jjjj. Still, a...

I have a file Auto Generated that has 2 columns - First labels and Second values Then I have a Master Reference sheet which contains references to cells from different sheets in a sub folder that contains values needed for the Second column in my Auto Generated file. Can I macro be prepared...

Hello :) I am trying to add several cells that contain values generated by the following formula. =IF(Y2="","",IF(Y2<=0,"",IF(Y2>=90,"10",IF(Y2>=80,"9",IF(Y2>=70,"8",IF(Y2>=60,"7",IF(Y2>=50,"6",IF(Y2>=40,"5",IF(Y2>=30,"4",IF(Y2>=20,"3",IF(Y2>=10,"2",IF(Y2<=10,"1")))))))))))) I keep getting...

I'm trying to countif any number in a column 10,000 rows deep is greater than, say 120. But, the 120 is generated by a formula, AND, the numbers are randomly generated. This means that the numbers in the columns are actually formulas. I can see numbers greater than 120 but my countif returns...

Hi I have a macro that populates a word document template from a table in excel. Users press a report generator button and it creates the file. However, for the cases as shown below where the user selects "compliance", "scope", or "vendor" in a specific cell i want the code to return a message...

The 2016 Box plot graph allows user to show "Inner Points". Has anyone figured out if VBA can check/uncheck this option? No code gets generated with the recorder. Thanks for time and help, -Erock

Hi guys, I posted a question regarding this recently but I don't think I worded it quite correctly and after some consideration have come up with a clearer (wordy) way of trying to calculate something which would be awesome if someone could convert to excel language for me! I am trying to...

Hi Guys, Total Newbie in Excel - but I can figure some things out. I have a list of product categories structured like this: Seasonal/Christmas/Trees/Ornaments/Red I would like excel to generate numeric values for each category and a random value for each individual product. So Seasonal...