Completed

breakdown an excel flat file into multiple files containing a part of the data 2

based on the value in the column "Cost Centre" (input is file with 1) at the beginning

Output is as many files as there are values in the column "Cost Centre"

Files should be like the 2 examples files with "2" at the beginning

Pivot tables should be maintained and refreshed in all files

Output files should be saved in same folder as input file

Real input file has around 500,000 lines and 7,000 values in "Cost Centre" colum

(so the output is around 7,000 excel files)

Skills: Excel, Data Processing, Data Entry, Visual Basic

See more: count number files flat file, import large excel file multiple worksheets, excel vba import multiple file worksheet, excel 2003 count multiple data formats, data excel word file table, create template flat file data service designer, multilingual excel file multiple languages, merge excel files remove data, create flat file excel file, flat file csv excel, net flat file data providers, compare flat file data database data change, csv file excel flat file, read data flat file cnet class, cnet copy data flat file, merge excel files common data, excel macro flat file, turn csv file multiple text files, copy data table flat file using

About the Employer:
( 1 review ) France

Project ID: #24129126

Awarded to:

whistler1987vw

Hello. I am computer vision engineer, that is a heavy Excel user and is proficient in automating boring and tedious tasks using Python/VBA. I cannot see the example files, but I would like to help out on this project More

$20 USD in 1 day
(1 Review)
1.8

13 freelancers are bidding on average $101 for this job

sergiuloghin

Hello! I can create the 7000 files using a VBA script. I am available and I can finish in 2-4 days. You will not be dissapointed, I have a big 30% rehire rate. Thank you!

$220 USD in 3 days
(309 Reviews)
7.8
rashedkhanrubel

Hi, I will make Visual Basic code to create new file based on data as per your requirement with good and professional quality without any error. I have completed more then 100 project within 8 months with 5 star revie More

$70 USD in 1 day
(119 Reviews)
5.7
usmnwaraich

Hi there, I have read your requirements and can do this work accurately and fast as you need in separate Excel files accurately and fast as I am expert in Excel. Please message me so that we can talk. Thanks

$700 USD in 15 days
(25 Reviews)
5.2
nurnga1218

Hi, Can you please send me the example of your file? I want to make one cost center example for you. And you'll see, so you can decide then. Waiting for your reply. Thanks

$30 USD in 2 days
(43 Reviews)
4.5
MonisZafar

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. If interested, we can discuss this further on chat.

$30 USD in 1 day
(11 Reviews)
3.9
VbaStudio

Hello, I'm an expert en Excel and macros and can do what you need. .....................................

$30 USD in 3 days
(2 Reviews)
3.0
Safiaezza

Hi my name is Safia and i am an professional excel and mostly expert in such projects, I have read your project info and fully understood what you need and ready to start your project right away and will complete withi More

$30 USD in 1 day
(1 Review)
0.6
$25 USD in 1 day
(0 Reviews)
0.0
Ameerjan83

I am well familiar in Data Entry, translation, photo editing, Excel, PPT and PDF file creation & designing data base setting. I will complete the Job on time in your provided SLA - service level agreement. i will make More

$20 USD in 7 days
(0 Reviews)
0.0
chamilatec

Thanking you Dear Madam / Sir, I felt I am the best candidate for this project, because my objective is to satisfy my client with my high quality, timely & dedicated work I am a full-time freelancer and available for 8 More

$100 USD in 7 days
(0 Reviews)
0.0
ikramhassan

I read your description and on behalf of my skills and expertise in MS Excel, VBA and data entry, I consider myself fit for this project and assure you 100% accurate results. Relevant Skills and Experience Its an str More

$20 USD in 1 day
(0 Reviews)
0.0
aradorphilip

Hi, Hope all is well. I came across at your project and I am very interested on it. It aligns well with my expertise and I surely believe that I can deliver this project beyond your expectations. Looking forward on More

$15 USD in 1 day
(0 Reviews)
0.0