Find Jobs
Hire Freelancers

Excel Data Manipulation (Sort & Copy)

$30-250 USD

Terminado
Publicado hace más de 5 años

$30-250 USD

Pagado a la entrega
I need to copy data from one excel worksheet to several others. 1) All the Data to be copied from (Source) is on the "Copy From This Sheet" tab - Need to copy based on the part number column. - the only data from each row that needs copied is part number, description, list price, qty, Desc(%) - Note that these column locations likely will NOT change, so can use column reference. 2) The part number for each row needs to be checked against the sheet named "part numbers" and sorted to tabs based on that list. 3) There are twenty (20) sets of tabs (called 1 - 20) though the attached sample only has two sets created for reference. Each set contains three "types". - Each type is used for sorting. - Type B is for anything that is found in the type b column in the "part numbers" tab. - Type C is for anything that is found in the type c column in the "part numbers" tab. - All part number NOT classified on the "part numbers" tab, go in Type A. 4) When parsing the data to copy, if there is a blank "part number" cell in a row, that starts a new "tab set" - up to twenty. See notes in the spreadsheet as well. **Match DESTINATION styles. Data should ONLY copy into the tables.... **The tab naming follows the same scheme for all 20 sets. **Code must be commented to note functions/steps from high level.
ID del proyecto: 17772182

Información sobre el proyecto

48 propuestas
Proyecto remoto
Activo hace 6 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
Hello, can you tell me more about point 3?, I can start inmediately and send the file back until the end of the weekend (as soon as possible). It will help me with my reputation because Im a new freelancers.
$45 USD en 2 días
5,0 (47 comentarios)
4,5
4,5
48 freelancers están ofertando un promedio de $117 USD por este trabajo
Avatar del usuario
Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 400 + projects with 100% client satisfaction. I can help you with Excel Data Manipulation (Sort & Copy) I have more than 5 years of the experience in Data Processing, Excel, VBScript, Visual Basic Please ping me for more discussion. Thanks.
$200 USD en 3 días
4,9 (551 comentarios)
8,4
8,4
Avatar del usuario
Hi there, I can copy data from one excel worksheet to several others. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
$100 USD en 3 días
4,9 (372 comentarios)
8,0
8,0
Avatar del usuario
Hello tkjoffs, I have checked the data in attached file and read your requirements. I can write VBA progrm with user friendly user interface.I have 5 years experience in Excel VBA programming, advanced concepts like Pivot table, Vlookup, Charts, Data analyser etc.. I can complete task within time with 100% accuracy. With Regards, Sai
$100 USD en 3 días
4,9 (484 comentarios)
7,7
7,7
Avatar del usuario
Dear client First of all thank you for giving your requirements in details. I understand completely what is to be done. And i ensure the job will be done to perfection. I will write the code for you. Kindly contact me. Roy
$100 USD en 1 día
4,9 (502 comentarios)
7,4
7,4
Avatar del usuario
copy data from one excel worksheet to several others. 4 varies parts to follows. A short brief specified above. It's for you that i understood project. Could you select me as your employee? Thank you
$250 USD en 6 días
5,0 (139 comentarios)
6,8
6,8
Avatar del usuario
Hi, As you are looking for automation using VBA macro in your excel sheet so that data will be distributed to different sheets based on part number. I will build the macro for you. I have many years of experience in Excel,data analysis, pivots and VBA macros etc. I have finished many such projects. Please give me this opportunity to work on your project. Quality work with high accuracy and 100% customer satisfaction is guaranteed. Thanks and regards, Mohan
$138 USD en 3 días
5,0 (93 comentarios)
6,4
6,4
Avatar del usuario
Hello thee, as an expert in excel and VBA, i can help you to develop the necessary code to handle data sorting and copying efficiently. Please contact me and let us talk more about your project. Thanks
$80 USD en 3 días
4,9 (85 comentarios)
5,8
5,8
Avatar del usuario
I am very able to sort, copy and organise excel data as per your requirement. I am ready to start. regards
$144 USD en 3 días
4,7 (54 comentarios)
5,8
5,8
Avatar del usuario
hello! I am very interested on your project, I would love to help you and you can be assured of a quality and accurate output from me. Hope you consider me! thanks
$100 USD en 3 días
4,9 (65 comentarios)
5,4
5,4
Avatar del usuario
Hello I am a highly skilled data processo ive worked on many simillar projects before i suggest to implement a script to auto perform the task /thank you in advance
$95 USD en 3 días
4,7 (29 comentarios)
5,1
5,1
Avatar del usuario
It would be my pleasure if you accepted my bid to work together. I can handle and deliver this task professionally. Kind regards, Amr
$80 USD en 3 días
5,0 (15 comentarios)
4,4
4,4
Avatar del usuario
Hello I would be able to help you. I have over 10 years experience with excel and vba for a global financial services company. In that time i became the local lead for all excel and vba issues where I designed and implemented many macros to automate systems and improve efficiencies. I have the skills required for your task. I look forward to working with you soon. Kind regards Steve
$138 USD en 3 días
5,0 (9 comentarios)
4,2
4,2
Avatar del usuario
Dear Employer; i would love to work for you. if you want your work done on time please contact me.
$30 USD en 2 días
5,0 (4 comentarios)
3,2
3,2
Avatar del usuario
If you don't mind I can do all this in powershell just because is something that I use on a daily basis.
$90 USD en 3 días
5,0 (2 comentarios)
2,9
2,9
Avatar del usuario
Hi there! I have read and understood that you need Excel Data Manipulation. I am highly skilled in excel with a typing speed of 86+ wpm and 98+% accuracy. Please initiate a private message so that we can discuss further and start work right away. Thank you, and have a great day! Arun
$133 USD en 2 días
5,0 (1 comentario)
2,2
2,2
Avatar del usuario
Hello, could you just clear me the purpose of Set1 and Set2 please? I've been reading the requirements for 30 minutes! Regards!! Chyedur
$50 USD en 2 días
5,0 (3 comentarios)
2,2
2,2
Avatar del usuario
As a professional accountant, I have a vast experience in working with Excel sheets and their features. I am highly accurate and precise in working with data. I would be glad to work on this project.
$50 USD en 1 día
5,0 (5 comentarios)
1,9
1,9
Avatar del usuario
------------------------------------------- I am a lazy person so I started automating my work and became an expert in it. I have handled huge data and processed them with my automation skills. I have 9 years of experience in the Excel sheets and macro. Handled huge data in office. Completed many automation projects.
$55 USD en 2 días
5,0 (3 comentarios)
1,5
1,5
Avatar del usuario
hey employer, i have recently completed work in excel and also i can complete your work in maximum 2 days .also if you want want i can create specific buttons for automation of whole process if its a regular entry work. for more further information like planning about this project you can inbox me anytime. thanks regards
$30 USD en 2 días
5,0 (1 comentario)
0,4
0,4
Avatar del usuario
Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do this job and give you an efficient job that will be very acceptable and presentable. I and my team work on web development and mobile apps and I can assure you that you will never be disappointed"
$208 USD en 7 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Tempe, United States
5,0
7
Forma de pago verificada
Miembro desde dic 12, 2010

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.