Find Jobs
Hire Freelancers

Create an Excel document with a macro for displaying a list of random values

€8-30 EUR

Terminado
Publicado hace casi 8 años

€8-30 EUR

Pagado a la entrega
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,
ID del proyecto: 10751955

Información sobre el proyecto

17 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
€30 EUR en 1 día
4,9 (195 comentarios)
6,1
6,1
17 freelancers están ofertando un promedio de €33 EUR por este trabajo
Avatar del usuario
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 en 1 día
4,9 (306 comentarios)
6,9
6,9
Avatar del usuario
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 en 3 días
5,0 (175 comentarios)
6,7
6,7
Avatar del usuario
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 en 3 días
4,9 (185 comentarios)
6,7
6,7
Avatar del usuario
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 en 1 día
5,0 (8 comentarios)
4,5
4,5
Avatar del usuario
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 en 0 día
4,9 (53 comentarios)
4,7
4,7
Avatar del usuario
I am an excel spreadsheet expert and I can complete your task effectively and efficiently in timely manner.
€111 EUR en 3 días
4,7 (35 comentarios)
5,2
5,2
Avatar del usuario
I understood your requirement and also saw the screenshot attached. I can do this for you. I am Microsoft Certified Excel Professional.
€34 EUR en 1 día
5,0 (29 comentarios)
5,0
5,0
Avatar del usuario
Hello. I have examined the screenshot and I wonder if you need to program a chart too. Best regards, Alexander.
€30 EUR en 1 día
5,0 (12 comentarios)
4,3
4,3
Avatar del usuario
Szia! Sok tapasztalatom van Excellel, es tudok segiteni ezzel a kis projekttel. Irj ram, es megbeszelhetunk minden tovabbi reszletet! Koszonom
€20 EUR en 1 día
4,6 (32 comentarios)
4,5
4,5
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have no work. Vacations have started so i have complete leisure time.I will be infant of PC doing nothing
€12 EUR en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I can send you a sample of the spreadsheet for you to review with code . I am exoerienced in excel macros
€23 EUR en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Delivered within 2 Hours
€29 EUR en 0 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de HUNGARY
Csobánka, Hungary
5,0
13
Miembro desde abr 6, 2016

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.