Find Jobs
Hire Freelancers

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

$250-750 USD

Completato
Pubblicato più di 5 anni fa

$250-750 USD

Pagato al completamento
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.
Rif. progetto: 17661276

Info sul progetto

35 proposte
Progetto a distanza
Attivo 6 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
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 in 1 giorno
4,9 (178 valutazioni)
6,5
6,5
35 freelance hanno fatto un'offerta media di $309 USD
Avatar dell'utente
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 in 4 giorni
4,9 (370 valutazioni)
8,1
8,1
Avatar dell'utente
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 in 3 giorni
5,0 (222 valutazioni)
7,4
7,4
Avatar dell'utente
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 in 7 giorni
4,9 (264 valutazioni)
7,6
7,6
Avatar dell'utente
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 in 3 giorni
4,9 (388 valutazioni)
7,3
7,3
Avatar dell'utente
I can do it for you quickly and exactly . Please contact me for saving your time and your money .
$250 USD in 3 giorni
4,9 (128 valutazioni)
7,1
7,1
Avatar dell'utente
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 in 2 giorni
4,9 (90 valutazioni)
7,1
7,1
Avatar dell'utente
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 in 0 giorno
5,0 (124 valutazioni)
6,4
6,4
Avatar dell'utente
Dear Sir, I can experienced excel developer. I can help with this. Looking to hearing from you soon. Kidn regards
$555 USD in 10 giorni
5,0 (108 valutazioni)
6,4
6,4
Avatar dell'utente
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 in 2 giorni
5,0 (86 valutazioni)
6,1
6,1
Avatar dell'utente
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 in 2 giorni
4,8 (143 valutazioni)
6,4
6,4
Avatar dell'utente
Hello. I have read your project description carefully and i can do it perfectly. Contact me please. Thanks.
$300 USD in 10 giorni
4,8 (100 valutazioni)
5,9
5,9
Avatar dell'utente
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 in 5 giorni
5,0 (83 valutazioni)
5,8
5,8
Avatar dell'utente
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 in 3 giorni
4,8 (122 valutazioni)
6,0
6,0
Avatar dell'utente
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 in 2 giorni
4,8 (92 valutazioni)
6,0
6,0
Avatar dell'utente
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 in 10 giorni
5,0 (16 valutazioni)
6,0
6,0
Avatar dell'utente
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 in 3 giorni
4,8 (95 valutazioni)
5,7
5,7
Avatar dell'utente
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 in 7 giorni
4,9 (31 valutazioni)
4,8
4,8
Avatar dell'utente
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 in 3 giorni
5,0 (8 valutazioni)
4,3
4,3
Avatar dell'utente
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 in 2 giorni
5,0 (8 valutazioni)
4,4
4,4
Avatar dell'utente
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 in 0 giorno
4,9 (38 valutazioni)
4,5
4,5

Info sul cliente

Bandiera: UNITED STATES
San Diego, United States
5,0
1
Metodo di pagamento verificato
Membro dal ago 29, 2018

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.