generate

I have been asked to help create a modulus number database with a prefix E and it has to be a 7 digit as the example next 806342 7.I have no idea how to start this. I have researched and looked at some of the formulas but I don't know how to generate a spreadsheet (CSV) file to import into a...

Hi all Seek help. My excel level is just average with only little knowledge in VBA. I am looking for a simple VBA to self generate numbers with a given number with no duplicate. Example: In A1, I have 1234. A simple VBA which can generate number in a column B1, a series of numbers based on A1...

Hi, there. Is there a way to generate a unique ID in for a row based on some adjacent cells? 1. If the row is unique from any other row, it gets a unique ID. What would make it unique is if just one of the cells' values is different from another row. 2. If the end of row doesn't yet have an ID...

Hi all Seek help. Is there a formula to self generate numbers with a given number with no duplicate. Example: In A1, I have 1234. What formula to use to generate number in a column B1, a series of numbers based on A1 (1234) until there is no repeat. cheers

generate the 7 3-letter formations a b c possible example = aaaaaaa, aaaaaab .... ccccccc

Hi there, I would like to create a macro that would save me so much time and also be fully correct as my current approach is quite manual. Let me describe what I require: Inputs; Team Name- this will list the teams taking part - this will range from 1-16 Number of Groups - this will be range...

Can you advise in very simple terms, how I can get a spreadsheet with our colleagues birthdays to automatically generate a personal birthday email please?

I have been working within my company creating UserForms on excel for multiple different inputs and outputs. I'm getting the stage where I feel comfortable to move forward and create an actual program outside of excel. However, I am unsure of the best language for this. Currently I build...

hello, generate all the formations of the 3 letters in the following criterion = no more than 5 letters for each of the 3 lines a = 01 02 03 04 05 06 07 08 09 1 0 b = 11 12 13 14 15 16 17 18 19 20 c = 21 22 23 24 25 26 27 28 29 30 31 So the formations will have 7 letters the maximum...

hi pls help In excel, i have 7 sheets. When i save the excel file save or ctrl s, how can i generate sheet 2 named 'calculation' in pdf format with a datetimestamp in a specific folder ? file name: worksheetName<datetimestmp>.pdf folder D:\test\

hi friends.. How to do: i have 23 sheets with similar structure and format... so so each sheet the minimum rows was 10 (and 20 cols) and the maximum rows was 150 (and 20 columns). my question is how to generate unique sheet... with all info of the 23 sheets. thanks

Unfortunately I cannot connect PowerBI to Salesforce and I will need to generate reporting in PowerBI from the exports in Salesforce which are in Excel. Do you recommend creating an Excel template for which you copy and paste the data into so automatically generate in PowerBI? Or can you load...

Hi There, I have a challenging question.... I have an existing macro that split the mastersheet into splitted sheets in the same workbook and it saves also the splitted sheet. And now I want that it generate for every splitted sheet a unique number in a cell with an prefix like "invoice" and...

All a google search turned up was code that I could put into a macro that will essentially save a log of when it runs, but seems to only be forward-looking. I.e. will keep a log of all times that macro runs going forward, but I'm trying to clean up my Modules and want to get rid of all the...

I have a single workbook with several worksheets. I would like to generate a list of names and have them added to my sheet named "Data", in column L which has a header in L1 of "Sheets Names". Each sheet has the tab name listed in cell CA1. I have the code listed below to generate the list of...

Is there a way I can generate a random alphanumeric string but with the 3rd, 10th and 17th characters having been specified? My current string looks like this; The 3rd, 10th and 17th characters will be stored as variables probably, though yet to do that part.

can anyone come up with a replica for the sequence function for Excel 2016? not the type which spills over, but rather one you can use in 1 cell. Lets say MyCustomNumber = 4 for example, instead of doing =ROWS(INDIRECT("A1:A"&MyCustomNumber)) to generate ={1;2;3;4} when evaluating [F9] in...

I have about 1000 sheets (each unique sheet names...not Sheet#####). All sheets have a value in a merged cell B8:E8. How can I create a list in a blank summary sheet using a formula or VBA ?

I have to create a spreadsheet where employees click on a number 1-41. Each number is in its own cell and each number is hyperlinked to another tab where the user is presented with a question they have to answer. What I am trying to do is use RANDBETWEEN to generate a random number between...

Hi Every One. Hope You all were enjoying good health. can anyone help me to generate auto ID based on cell value like...