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

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.

Sorry, but request is slightly different but hoping similar effort and pricing. Really need to know if someone can automate the VBA code already created. I'm updating AutoFilter for every value, but there has to be a better way. Just don't have the time to research it.

Kemahiran: Pemprosesan Data, Excel, VB.NET, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: excel vba save worksheet as new file, save sheet as new workbook vba, vba save as xlsm, excel vba save multiple sheets as new workbook, vba code to save worksheets in different workbooks, vba save as xlsx, excel vba save workbook in specific folder, macro to save excel file with new name, excel vba coding ftp connection, macro coding copying info web excel, freelance vba coding hourly rates, vba coding changing action workbooks, excel macro vba coding, downloading file ftp site vba coding, excel vba update sheets projects workbooks, excel 2003 vba coding, vba coding job, vba coding word user form template, excel vba coding project, vba coding fedex tracking

Tentang Majikan:
( 1 ulasan ) San Diego, United States

ID Projek: #17661276

Dianugerahkan kepada:


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. P Lagi

$250 USD dalam sehari
(174 Ulasan)

41 pekerja bebas membida secara purata $314 untuk pekerjaan ini


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Lagi

$333 USD dalam 2 hari
(666 Ulasan)

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 Lagi

$400 USD dalam 4 hari
(307 Ulasan)

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. Lagi

$250 USD dalam 3 hari
(221 Ulasan)

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 al Lagi

$400 USD dalam 7 hari
(179 Ulasan)

I can do it for you quickly and exactly . Please contact me for saving your time and your money .

$250 USD dalam 3 hari
(118 Ulasan)

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 expertis Lagi

$300 USD dalam 2 hari
(70 Ulasan)

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 p Lagi

$250 USD dalam 3 hari
(327 Ulasan)

Hi, I have created the automation script for your excel spreadsheet at: [login to view URL] You can save it to a new folder on your pc. The macro Lagi

$250 USD dalam sehari
(207 Ulasan)

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 le Lagi

$250 USD dalam 2 hari
(141 Ulasan)

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. Lagi

$250 USD dalam 0 hari
(76 Ulasan)

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 a Lagi

$500 USD dalam 10 hari
(16 Ulasan)

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 dalam 5 hari
(80 Ulasan)

Dear Sir, I can experienced excel developer. I can help with this. Looking to hearing from you soon. Kidn regards

$555 USD dalam 10 hari
(64 Ulasan)

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 com Lagi

$250 USD dalam 2 hari
(80 Ulasan)

Hi Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These are screenshots of some of my work Lagi

$250 USD dalam 3 hari
(69 Ulasan)

We can isolate the data according to the Column team in multiple sheets named as Team variants of the same workbook. PM me for the tool. If you need individual workbook we could do that also. Price might be 120 USD d Lagi

$250 USD dalam 6 hari
(79 Ulasan)

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 Lagi

$250 USD dalam 3 hari
(104 Ulasan)

- Went through the Worksheets attached including the sparkline charts. [login to view URL] [login to view URL] - Can get the filtering done, and copy the file in new name Lagi

$250 USD dalam 2 hari
(51 Ulasan)

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 Lagi

$250 USD dalam 2 hari
(54 Ulasan)

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 Lagi

$250 USD dalam 3 hari
(72 Ulasan)