Find Jobs
Hire Freelancers

Excel worksheet data extraction

$30-250 USD

Terminado
Publicado hace más de 5 años

$30-250 USD

Pagado a la entrega
I have 4-6 separate commission reports that are all either CSV for excel files. They all have multiple columns of information but I only need 7 or so columns from each spreadsheet. Each column is named differently and in different orders between the reports. I need to extract the 7 columns that I need from each report and combine them into one master report. The 4-6 commission reports will be a new file every month. I need the information to stack on top of each other in the master report. For example, if commission report #1 has 3 sales that information will be in lines 2-4. If commission report #2 has 5 sales that information will be in lines 5-9. And so on. I need someone to create a formula or VBR or something else so I can simply choose the 4-6 separate commission reports to use in the formula and click a button. All you Excel experts out there, is this possible?
ID del proyecto: 17762300

Información sobre el proyecto

50 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
I am proficient with excel macro/VBA development, I can write the macro to perform the data manipulation as specified in your project, if you are interested feel free to message me, I am available to start your project immediately, looking forward to chat further and work on your project
$50 USD en 3 días
5,0 (97 comentarios)
6,1
6,1
50 freelancers están ofertando un promedio de $123 USD por este trabajo
Avatar del usuario
Dear Employer, Yes its very much possible. I understand most of the things in your job. Please message me. I will do the job for you. Thanks and Regards, Ash
$200 USD en 3 días
5,0 (187 comentarios)
7,6
7,6
Avatar del usuario
Hi, if let's say Report1, will have always the same structure (the same column order and names), so I can code a macro where you will select the 4-6 files and the master report will be generated. If even the same report can also change the structure, so we have to find another sophisticated solution which will be more complexe and more expensive. Please let me know more details. Thanks
$50 USD en 2 días
4,9 (296 comentarios)
7,7
7,7
Avatar del usuario
Hello! My name is Paris and just had the chance to read your project's brief. I was very excited that you mention Microsoft Excel because this is my favorite field and MS Excel projects are among the tasks I work with regularly and know exactly how to handle them. You mention that you need somebody to automate the process of retrieving data coming from 4-6 separate files and located in different columns. This can be done through VBA code and I can do it for you. You can have the reports in a single folder. the code will detect the correct column and will bring the right data in. I'm going to spend less than 2-3 days to complete your project including required revisions for a total payment of $150. I never ask for any payment in front. I claim the milestone release once the project is completed and my client is happy with the result. I'm a very experienced and skilled MS Office developer as you can easily check for yourself. You're welcome to visit my personal page on this platform and get an idea of who I am and what services I deliver to my clients. I'm looking forward to hearing from you. Sincerely, Paris Pallas
$150 USD en 3 días
4,9 (236 comentarios)
7,4
7,4
Avatar del usuario
That is very much possible with the click of a button with the VBA script behind. Hello there, This looks feasible and I can do this quickly. I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project , timeline and budget. Thanks A
$96 USD en 1 día
4,9 (176 comentarios)
6,5
6,5
Avatar del usuario
Hi there, I’ve checked the project details and I can do this perfectly. I have huge experience in working with these projects. Waiting for your quick reply. Look forward to hearing from you soon. Best Regards
$155 USD en 3 días
4,9 (127 comentarios)
6,5
6,5
Avatar del usuario
I am ready to start right now.I am a full time dedicated freelancer. Dear Hiring Manager, I have read your job description carefully and I’m very considering your job such as these capabilities. I have fantastic experience in this fields such as Data Entry, MS Excel and other related tasks. I am full time dedicated freelancer. I have 3 years+ experience in these categories. I believe my capabilities would be ideal for you. I can complete this job within the necessary period. You can get hold of me instantly to discuss this position further. I am waiting for your kind respond. I am ready to start right now. Thanks. Best Regards, Masud
$50 USD en 3 días
4,9 (151 comentarios)
6,2
6,2
Avatar del usuario
am not a random bidder.. Please ping me if you are interested iwth my proposal and share sample reports.. thank you..
$250 USD en 3 días
4,9 (28 comentarios)
5,0
5,0
Avatar del usuario
Hello.....! I read carefully the project description. I got understand it. I'm highly interested. I have properly skill on ## Admin Support ## Real State ## Web/Internet Research ## Address Finding ## Review Writing ## Email find expert ## Linkedin email hunting ## Potential Lead Generation You can hire for my another skill. Other Skills ## Data Entry ## Email Scraping ## Information Collection ## Data Collection ## Web/Data scraping ## Email Extraction ## Web Data extraction ## Image Extraction (can also organize them by renaming and moving to folders) ## MS Excel expert ## Wide range of output format (Excel, CSV, XML, SQLite, SQL Server Compact) So if you have any related work , please contact me
$45 USD en 3 días
4,8 (21 comentarios)
4,9
4,9
Avatar del usuario
Hello I saw your project and I understand and I can do this because I have good experience about this and if you give me your project then I will give your good quality work
$70 USD en 3 días
5,0 (18 comentarios)
4,4
4,4
Avatar del usuario
Hello Sir, Have a great day ahead I went thru the description and this task can be done Kindly contact me and send your excel csv file I will start it by today I look forward to hearing from you Thanks regards Thushara
$100 USD en 3 días
5,0 (29 comentarios)
4,4
4,4
Avatar del usuario
Hello! I am an Excel expert from the US who should be able to help you with this project without any problems. I would love to chat with you and learn more about what you are hoping to accomplish just so I don't miss any details. Thank you for the opportunity!
$250 USD en 3 días
5,0 (28 comentarios)
4,5
4,5
Avatar del usuario
Hi Good day! A serious freelancer here! I have a lots of available time for this type of work.i just need to have the full requirements so I can assess how long would it take to complete this. I am VBA Macro developer for 6 years now. I have a strong knowledge with Excel formulas and function that will help for this type of work. I am also a PMO Analyst that focused in Financial and Metrics Reports. My rate is negotiable because I'm still collecting good reviews and portfolio that I can show to my future clients, so please accept my bid. Feel free to message me to discuss more about the scope of this project. Thanks!
$50 USD en 3 días
4,9 (36 comentarios)
4,5
4,5
Avatar del usuario
Hi, Price and duration is negotiable. I am expert in Excel having 12 Yrs Professional experience. I’ll complete task with 100% Accuracy and in least possible time. I assure you, you will be another 100% satisfied client. I am regularly doing following kind of tasks: I have 4-6 separate commission reports that are all either CSV for excel files. They all have multiple columns of information but I only need 7 or so columns from each spreadsheet. Each column is named differently and in different orders between the reports. I need to extract the 7 columns that I need from each report and combine them into one master report. The 4-6 commission reports will be a new file every month. I need the information to stack on top of each other in the master report. For example, if commission report #1 has 3 sales that information will be in lines 2-4. If commission report #2 has 5 sales that information will be in lines 5-9. And so on. I need someone to create a formula or VBR or something else so I can simply choose the 4-6 separate commission reports to use in the formula and click a button. Thanks. Faisal S.
$100 USD en 3 días
5,0 (19 comentarios)
4,0
4,0
Avatar del usuario
The better solution is on Access database. You could link the sheets and merge & generate the report like you want. Then, export this to Excel file. Please, contact me and we could make a little test to show you.
$222 USD en 2 días
5,0 (8 comentarios)
4,0
4,0
Avatar del usuario
I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, charts, advance formulas, formatting, macro etc. thanks
$120 USD en 2 días
4,9 (23 comentarios)
4,0
4,0
Avatar del usuario
i can share you the required values within 2 hour i will use excel formulas for this purpose will charge you minimum amount Looking forward to hear from you. Thanks Faisal
$30 USD en 1 día
5,0 (5 comentarios)
3,7
3,7
Avatar del usuario
Hi There, I have understood your requirements. I am a Data Entry/Web Research/ Data Research and data Uploading specialist. I have years of experience in managing, updating researching & adding Online data records on CRM. I am so confident to take up this opportunity to provide you with 100% accuracy of results. I am also ready to do first 1 Hours of service as a trial free of cost to ensure you the quality and accuracy of my work before hiring me. Waiting for your response! Thanks & Regards, Samol
$100 USD en 2 días
4,2 (3 comentarios)
3,0
3,0
Avatar del usuario
Hello Sir, I'm an experienced and highly professional excel expert. I can assure you about top quality work on your project. Your project is what I'm specialized in. Can we discuss sir? Thanks
$200 USD en 3 días
5,0 (3 comentarios)
2,1
2,1
Avatar del usuario
Hello Thank you for posting. I have read your post carefully. I am familiar with Excel. I already have experience in developing something like this. And I am also a full stack developer. If you share me your site, I will check carefully. Thanks......
$150 USD en 3 días
5,0 (1 comentario)
1,5
1,5
Avatar del usuario
i can help you with your project. just give me all the details needed so i can finish the work perfectly.
$30 USD en 3 días
5,0 (3 comentarios)
1,3
1,3

Sobre este cliente

Bandera de UNITED STATES
ANKENY, United States
5,0
10
Forma de pago verificada
Miembro desde jul 24, 2018

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.