Create an Excel document with a macro for displaying a list of random values
€8-30 EUR
Completed
Posted almost 8 years ago
€8-30 EUR
Paid on delivery
Dear Freelancers,
I would need a macro for excel with 2 buttons on the worksheet, one that generates a list of 500 random and unique combination of numbers, the second button adds 2 other random numbers besides each row. (please see screenshot attached as an exemple)
I would also need a precise description how to use the macro in Excel you provide me, where to past it so that it works (I am a beginer in Excel). Or you should send me an excel doc containing the macro so that I just click on the buttons. : -))
1) Clicking on First button (called Nombres) would do this:
Create a list of 500 rows.
Description of the list:
First Row:
Column A, B, C, D, E contains a random number between 1 and 50.
Each number has to be different in each column (if num in B is same than in A, choose a new number, in C if same than A or B, then choose another number etc.)
Then set the numbers in that row from the smallest until the biggest, then finally the numbers can appear in that row.
Next Row:
Same as above, but needs to have a serie of numbers with at least one number having a different value than in all the rows above, if it is different that serie of numbers can appear also (i don't want duplication of lotto combinations in the list), if the serie of number in that row is the same than one of the rows above, then create a new random serie of numbert and if at lease one of the number is different, then that row can be accepted / printed
Then the macro can create next row until the 500th row.
2) Clicking on Second button (called Étoiles) would do this:
Add 2 random numbers (in RED color) at the end of the serie in each row randomly between 1 and No duplication test is needed for that second part, it should be random..., but it does not matter if there is a repetition within those numbers.
Then if I click on first button a get a new list again of 500 rows, and if on 2nd button, then a new list again besides all the rows.
I would need it within some hours if possible.
Kind Regards,
Hello Sir
Im excel VBA macro and formula Expert :)
i can make random number via VBA macro excel Sir :)
please give me a chance for doing your job and im able to start doing your job right now
Thank You
Sincerely
Prameswara
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros.
Check my reviews. They speak for themselves.
Best regards
hello,
i'd be glad to provide you with an excel file with the macro you're lookng for. Please do not hesitate to contact me on chat for more details.
Best regards;
Hello,
I have read your requirements and I can help you in this. I'm excel developer and I know how to work with macros. Deliverable file will be excel file containing macro. I could also send you the code (or you can see it in excel and I can make an explanation of each part for you)
This macro you need is in french from names button I guess, je parle un 'tit peu francais.
Then, I hope you contact me soon to have this done in few hours as you need.
I hope hear from you soon!
Kind regards,
Luis Romero
I am a Data Entry/Data Processing Expert with years of experience. I also have experience in word and excel. PDF to Word and Excel. I know the value of time. I am very hard working and always deliver work on time. My motive is to make my employer Happy without additional charges. If you are looking for data entry work, I am the right person for you. I hope to deliver you the best of best services. Hire me to get the job Expertise LEADS GENERATION Web Search Web Scrape Research Work Excel and Word Data Entry and Solutions E- Commerce sites Data Entry Data entry PDF to Excel & Word Mailing List Development Scraping Work