Find Jobs
Hire Freelancers

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,
Project ID: 10751955

About the project

17 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
€30 EUR in 1 day
4.9 (195 reviews)
6.1
6.1
17 freelancers are bidding on average €33 EUR for this job
User Avatar
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
€30 EUR in 1 day
4.9 (306 reviews)
6.9
6.9
User Avatar
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
€30 EUR in 3 days
5.0 (175 reviews)
6.7
6.7
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
€30 EUR in 3 days
4.9 (185 reviews)
6.7
6.7
User Avatar
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;
€25 EUR in 1 day
5.0 (8 reviews)
4.5
4.5
User Avatar
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
€30 EUR in 0 day
4.9 (53 reviews)
4.7
4.7
User Avatar
I am an excel spreadsheet expert and I can complete your task effectively and efficiently in timely manner.
€111 EUR in 3 days
4.7 (35 reviews)
5.2
5.2
User Avatar
I understood your requirement and also saw the screenshot attached. I can do this for you. I am Microsoft Certified Excel Professional.
€34 EUR in 1 day
5.0 (29 reviews)
5.0
5.0
User Avatar
Hello. I have examined the screenshot and I wonder if you need to program a chart too. Best regards, Alexander.
€30 EUR in 1 day
5.0 (12 reviews)
4.3
4.3
User Avatar
Szia! Sok tapasztalatom van Excellel, es tudok segiteni ezzel a kis projekttel. Irj ram, es megbeszelhetunk minden tovabbi reszletet! Koszonom
€20 EUR in 1 day
4.6 (32 reviews)
4.5
4.5
User Avatar
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
€24 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have no work. Vacations have started so i have complete leisure time.I will be infant of PC doing nothing
€12 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I can send you a sample of the spreadsheet for you to review with code . I am exoerienced in excel macros
€23 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Delivered within 2 Hours
€29 EUR in 0 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of HUNGARY
Csobánka, Hungary
5.0
13
Member since Apr 6, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.