Find Jobs
Hire Freelancers

VBA Coding for Saving, Copying, and Saving to New Workbooks

$250-750 USD

Terminado
Publicado hace más de 5 años

$250-750 USD

Pagado a la entrega
I have an Excel file with conditional formatting and sparkline charts. I want to filter a column by one value, copy to new workbook, and save as new file with filename of filtered value (or overwrite an existing file) then repeat. I'm looking for an automated solution to the problem. In the sample file uploaded below, the goal would be to have 32 separate files named by team (column F) and only each team's data in each separate file. Conditional formatting and sparklines still present is required. I would also still want the master file in tact as well. I provided a sample master file and a team output file (filename preferred: [login to view URL]) Let me know projected hours and rate. Thanks.
ID del proyecto: 17661276

Información sobre el proyecto

35 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 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
$250 USD en 1 día
4,9 (178 comentarios)
6,5
6,5
35 freelancers están ofertando un promedio de $309 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 390 + projects with 100% client satisfaction. I can help you with VBA Coding for Saving, Copying, and Saving to New Workbooks I have more than 5 years of the experience in Data Processing, Excel, VB.NET, Visual Basic, Visual Basic for Apps Please ping me for more discussion. Thanks.
$400 USD en 4 días
4,9 (370 comentarios)
8,1
8,1
Avatar del usuario
Hi, My main skill set is Excel VBA coding and have been active in this field for more than 10 years. I have studied your requirements and would be able to provide you with an Excel VBA based solution within 3 days. Let me know. Regards, Arul
$250 USD en 3 días
5,0 (222 comentarios)
7,4
7,4
Avatar del usuario
Hello! My name's Paris and I was glad to see that you're looking for an Excel developer. You mention that you need somebody to automate your process of copying fltered data to new worksheets which is something I've already implemented in the past. I've delivered more than 240 projects in the last 5 years and this makes me very comfortable with your task. I can deliver the project within 7 days including all required revisions for $400. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon. Paris Pallas
$400 USD en 7 días
4,9 (264 comentarios)
7,6
7,6
Avatar del usuario
Hello Sir Im excel VBA macro and formula Expert :) i can make macro for make your work automatic Sir, i can make conditional formatting automaticly, copy data into new workbook and save as it automaticly and etc please give me this job and im able to start working today Thank You Sincerely Galih AP
$250 USD en 3 días
4,9 (388 comentarios)
7,3
7,3
Avatar del usuario
I can do it for you quickly and exactly . Please contact me for saving your time and your money .
$250 USD en 3 días
4,9 (128 comentarios)
7,1
7,1
Avatar del usuario
Hi, I’ve read your proposal and I can copy formatted rows to new workbooks by team_abb and creating a master file as well. I am a financial expert and guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. Furthermore, I have an experience in dashboards, financial reports, accounting, consolidating, forecasting, budgeting and cost acquisition based on inventory, bill of materials, collections, payments, and bank reconciliation. With these skills, I develop financial modules including depreciation schedule, long-term debt, business valuation methodology & ratios The modules incorporate complex components of business in a simplified and logical manner.
$300 USD en 2 días
4,9 (90 comentarios)
7,1
7,1
Avatar del usuario
Thank you for the additional information. Yes, there is other ways of selecting values and taking only the rows to the new workbooks. I can do it in a couple of hours. if you are comfortable I can do it for 100 USD. May be you need to hire me directly for couple of hours as this project will not allow me to bid less than 250 USD. Thank you -- Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. can do it quickly for you within a few hours, as I have already worked on simillar project and just need to redo it for you. Willing to take up your project. Thank you, Regards.
$250 USD en 0 día
5,0 (124 comentarios)
6,4
6,4
Avatar del usuario
Dear Sir, I can experienced excel developer. I can help with this. Looking to hearing from you soon. Kidn regards
$555 USD en 10 días
5,0 (108 comentarios)
6,4
6,4
Avatar del usuario
Hi, I have checked your project description and attached sample files. I will develop automated process for you to achieve this goal. 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
$250 USD en 2 días
5,0 (86 comentarios)
6,1
6,1
Avatar del usuario
Hi, Greetings. I have checked the attached resources. However, it could be done in your required way, just need to work on it for writing codes. It would take least 48 hours, might increase 12 hours most. Plz let me know if you are interested. Thank you.
$250 USD en 2 días
4,8 (143 comentarios)
6,4
6,4
Avatar del usuario
Hello. I have read your project description carefully and i can do it perfectly. Contact me please. Thanks.
$300 USD en 10 días
4,8 (100 comentarios)
5,9
5,9
Avatar del usuario
Hello thee, as an expert in excel and VBA, i can help you to develop a macro for this automation process. Please contact me and let us talk more about your project. Thanks
$250 USD en 5 días
5,0 (83 comentarios)
5,8
5,8
Avatar del usuario
Hi, Being experienced in working on several excel/vba projects of various complexities, I can take up your task to complete it quickly and efficiently. To give you an idea, i will create one button on click of which vba code will fire which will read master file and based on different teams separate files will be created having only its data. Also, budget you put is relatively high. We can discuss and can finalize deal at $150. Waiting for your response on the chat to discuss in detail. Thanks. Update - I checked your existing code. I can modify it to work as per your requirement based on all filters. Kindly respond on chat to discuss. Thanks.
$250 USD en 3 días
4,8 (122 comentarios)
6,0
6,0
Avatar del usuario
I can write a macro to create (or overwrite) Excel files per team. I can deliver within 2 days (and even within a day if urgent) and for $150. (I will use a different approach, not auto filter) I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Built a delivery schedule for pick-up and drop of raw-material under given constraints optimizing the utilization of available resources - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana
$250 USD en 2 días
4,8 (92 comentarios)
6,0
6,0
Avatar del usuario
Workbook expert to build any kind of Excel data sheet automation by using Excel VBA Macros. Also I can build Windows Application Software by using Visual Basic to automate Excel files. Which will search and calculate and save in individual file. Have more than 15 years of experience on Visual Basic. 15+ years of experience on Computer Language and Digital Electronics.
$500 USD en 10 días
5,0 (16 comentarios)
6,0
6,0
Avatar del usuario
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully and saw both attached files. I can develop a macro to automate this process. The macro can extract data from specific column, preserve conditional formatting and charts, save it to new workbook with desired file name. All this process will be automated. I have excellent knowledge and experience of Manipulating Data of Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra
$250 USD en 3 días
4,8 (95 comentarios)
5,7
5,7
Avatar del usuario
Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards. Passionate about excel automation.
$300 USD en 7 días
4,9 (31 comentarios)
4,8
4,8
Avatar del usuario
Hi we are a software development company from india in past 8 years me & my Team developed Multiple projects for Software World , we have lots of global clients from manufacturing , retail stores , wholesale business, schools , hospitals ,where we had completed all the modules according to customer requirements we did lots of similar kind applications we would like to discuss more about project ... so that we can know more about requirements Thanks
$250 USD en 3 días
5,0 (8 comentarios)
4,3
4,3
Avatar del usuario
Hello, I am a Excel VBA expert and have plenty of good experience of it. I read your project description posted. However, I'd like to discuss more detail with you now. I am free to work now. Kindly send me a chat. Looking forward your quick contacting. Regards
$555 USD en 2 días
5,0 (8 comentarios)
4,4
4,4
Avatar del usuario
My Bid "50$" & delivered less than a day Hi I am "VBA Developer". Expert in Web Scraping & VBA Macros.. Outlook Automation i can scrape any website.. & Python programming, Google Apps Script coding, Wordpress Developement, HTML, VB.Net I will do this task in a Day Only.. Thankyou~
$250 USD en 0 día
4,9 (38 comentarios)
4,5
4,5

Sobre este cliente

Bandera de UNITED STATES
San Diego, United States
5,0
1
Forma de pago verificada
Miembro desde ago 29, 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.