generate

hi all, I am creating a PO generator and excel I need support. 1. I want to generate PO number in the format as ex: companyname/projectdescription/Projectcode/SLNO like ABDC/CSM/AA456/001. here variable is project code , projectdescription,SLno. this PO number has to trace the last PO number...

Hi Guys, Can you help me out as I need to generate 7 numbers between 40-80 which should total 450 but the number must end with either 5 or zero- I am unable to find it so if somebody can help me that would be very nice. Cheers Prabin

Hello Excel lent people My challenge is i would like to generate all betting possibility in a 13 Matches,with 2 games each ,with usual outcomes of 1,X.2 such that there will be 3^13 outcomes -1594323 results, I dont know much about Excel/VBA formulas but i would really like to have a...

Hello! Is there a quick way to generate a list of the weekday dates between a starting and an ending date? Without weekends? Thanks!

generate all 7-letter formations, maximum 3 letters repeated. ex = aaabcde ... bbbcccd, etc. we have 10 letters = abcdefghij to conbine the formations with 7 letters please!

Hi everyone I'm trying to write some code to automate a search we carry out at my company over 64 spreadsheets, with 6 sub-sheets apiece. Due to the typical large-company 'left hand, right hand' issues and due to strict policy, merging the spreadsheets is not an option. As such I'm looking at...

Hello, I need a VBA code to generate serial numbers as described in the below image (link) Can somebody please help me with this...?? Thank you very much in advance...! http://drive.google.com/file/d/1pFIU3cghghJAuYApKUtx1kYFcD1Ec7bb/view?usp=sharing

Hi, I need help to generate serial numbers as explained in the image (below link) Sorry I didnt understand how to attach an image in this form.. Solution either in the form of formula or in the form of vba code, both are acceptable... Thank you in advance...

I am trying to generate random time entries Between two time limits in Excel. the problem i am facing is the generation works fine with the same day time calculation as soon as the time passes midnight, Excel gets confused and give me wrong values values. I need to generate random entries then...

Hi All, Quick question. I want to generate a list of random numbers each 125 digits long, including zeros, with a full output - not reduced to an E+ number. Excel seems to have limit on the RAND and RANDBETWEEN after about 17 digits. Any suggestions appreciated. Thanks,

Hi, Can any one help e out, i am trying to create Macro file which can compare two identical excel reports (Workbook) and generate difference report with same layout and formatting. Thanks Satyartha

good evening, I use the following:- Sub Gencode() Static IsRandomized As Boolean Dim i As Integer, PW1 As String Dim cell As Range, PW As String With Sheets("code") ' Change Code to the name of the sheet this is to work on. .Unprotect If Not IsRandomized Then Randomize...

Hi, I have some table data where I would like to generate an aggregate reciprocal position. This relates to modelling allocation of costs within an organisation. E.g. 5 departments a, b, c, d, e receive costs of -1, -2, -3, -4, -5 respectively. I would like to generate in the cleanest and...

Hi all, I am really a beginner and a little bit ashamed because I could not find after extensive search how to generate a simple array (One dimension) but depending on 3 parameters. I would like to create a serial dilution array where the inputs are: Concentration of stock solution, dilutional...

Hello! I have two columns: [*=1]X ranging from 300 to 1050 (cells AB53:AB803) [*=1]Gaussian Model I would like the Gaussian Model column to fill in with Gaussian values. Not sure if this makes any sense. Here is a somewhat basic example of what I mean. Example: I want to generate...

I collected a list of around a 1000 names an was able to generate random Male and Female names. However, I would like to specify what letters the names should start with. For example, I have someone whose initials are S.B. I need to generate a random American name with those initials. I'm using...

Hi, I would like to ask how to create code that will generate an error message for duplicate table heading names (by column) in VBA, but if I duplicates then it runs the rest of the code to generate the relevant values.

HI I have an Excel Sheet and I'm trying to Auto Generate Lab# in Column A(see the format is Screenshot) when Bulk Code is entered in Column B When I click Fill data Button I know basic of VBA but I Can't Figure How I can Auto generate Lab# Link to Screenshot Image...

Hello forum. I have a question about generating an array based on a certain set of parameters. In the example table at the bottom of this post, the first row of numbers (1, 2, and 3) represent desired values, and the second row (4, 3, and 2) represent the desired frequency of each of those...

I have a list in excel which may vary from 1 to multiple. I need to create a macro where I can generate a letter in MS word with details of all lines in the letter. The list can be 1 or more than 1 items. <tbody> Item MRP Discount SP 1 2 </tbody>