separate an excel file

$30-250 AUD

Slutfört

Publicerad

över fem år sedan

$30-250 AUD

Betalning vid leverans

SORRY - I SHOULD HAVE SAID I NEED THIS PROJECT COMPLETED URGENTLY - IE. TODAY...Hi, I have an excel spreadsheet with approximately 7,500 lines of data. I need it separated into different files with a maximum of 100 lines of data per file. The reason is the software I am uploading the data into can only take 100 lines per file. Therefore, we will end up with 75 separate spreadsheets (saved as .csv). First it needs to be sorted by date and then take 100 lines in date order ensuring the dates don't overlap across two files. For example, if you start at 1 December and then trade number 99 is date 31 December and trade number 100 is 31 December then you would leave 31 December for the next file so you don't have 31 December across two files. I think a simple copy and paste is a good option. I did December splitting it in two files called December 1 of 2 and December 2 of 2. This means I know there are two files for December. It took a couple of minutes actually less, but I understand some months will take more as there may be multiple files per month. So let's say each file takes 3 minutes, which it won't, but I'm happy to pay for that then that's around 4 hours work. roughly. but I would rather it done properly than rushed, so I am happy to pay for a bit more than that too. I will send the file to the person doing the work...thanks. ALSO, I don't think you should take on this project if you don't have two computer screens as I did the first one and it was much easier to copy from the main excel on the main screen and dump into the second excel file on the second screen. thanks

Data Entry

Data Processing

Excel

Project ID: 18626068

Om projektet

53 anbud

Distansprojekt

Senaste aktivitet fem år sedan

Ute efter att tjäna lite pengar?

E-postadress

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram

Få betalt för ditt arbete

Beskriv ditt förslag

Det är gratis att registrera sig och att lägga anbud på uppdrag

Tilldelad till:

@cgullapalli

HI, I am good at Data Entry, file comparison, and Excel. Please share the file, i will make a sample and get back to you to work on the rest. I have two computers. I can split the info based on the info given. At the most you want 100 in a single file. However, if the date is splitting, the whole set of date need to be moved a different file. Looking forward to work on the project. -Chandra

$100 AUD Om 0 dag

5,0

(1147 omdömen)

8,4

53 frilansar lägger i genomsnitt anbud på $96 AUD för detta uppdrag

@Innovative116

Hi there. I am a full time data processing, spreadsheet formatting expert. Compiling 75 different spreadsheets by setting database in alphabetical date wise order will be done with 100% accuracy within 2 days of project awarding. I have years of experience formatting/manipulating spreadsheets. Please check my feed backs for my expertise. I have multiple work stations and can start right away. Looking for more discussion via chat. Best, Harish

$175 AUD Om 2 dagar

4,9

(437 omdömen)

8,6

@semi786

Hi Sir/Madam, It is being my pleasure to introduce you to me. I will make separate an excel file for 7500 records and send you in 3-4 hours. Please send me file with 7500 lines. I will send you all files in one zip folder. I will complete this project on time. Please give me chance to work for you and provide me this opportunity. It will be glad for me. Thank You, Semi786

$40 AUD Om 0 dag

5,0

(590 omdömen)

8,5

@opu00

Greetings!!! I think I am the perfect person for this task. I have over 7 years experience in Web Search, Data Entry, Product Upload, Research related task. I am open to discuss more about your project, budget, time frame and ready to do some trail work before awarding the project. Awaiting for your response.... Thanks

$155 AUD Om 3 dagar

4,9

(677 omdömen)

8,4

@asin1987

Dear Employer, I will first sort your file by date and then will divide it by 100 row each and will give you separated files. Please message me to discuss further. Thanks and Regards, Ash

$222 AUD Om 1 dag

5,0

(288 omdömen)

8,3

@FINGERRPRINT

Hi there, I can split and get the 7500/100=75 files. Available immediately to start and send the file fast. Thanks

$150 AUD Om 1 dag

4,9

(398 omdömen)

8,3

@Ibrahim185

Hi, I am a data processing expert. I can help to separate the main file into different files with a maximum of 100 lines of data per file. Please send me the main file. Let's discuss and start. Thanks

$150 AUD Om 1 dag

4,9

(1007 omdömen)

8,4

@prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can make your existing file with 7500 row, separate with 100 row data each file. please ping me now and im able to make it now :) sure SIr i can make it in few hour from now :D please give this job to me :) Thank you Galih

$50 AUD Om 0 dag

4,9

(434 omdömen)

7,6

@BithiXpert

Hello Dear, I am an expert in Data Entry, Data Processing, Excel and I am really interested in your project. I am available to start working on it now. I work efficiently and will finish in a timely manner and will provide high quality work. I have great researching skills and would gladly work on your project. I am waiting to your quick positive reply and if you have any questions, feel free to ask me.

$50 AUD Om 0 dag

5,0

(421 omdömen)

7,7

@dgled

Hi, I can do it today, and I know how to do that. I am confident that my experience and my excellent knowledge of the Microsoft Office and Excel will meet your requirements and to meet your deadlines. I am financial experts and gurus in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application (automation) including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (script for charts). Furthermore, I have experience in accounting, financial reports, consolidating, forecasting, budgeting, costing, cash flow, multi-currency, including collections, payments, inventory, bill of materials, taxation and bank reconciliation.

$250 AUD Om 3 dagar

4,9

(95 omdömen)

7,5

@TonmoyRoy111

Dear client I will finish the job in quick time. I have read the whole description and i completely understand the scope of work. I ensure that the work will be spot on. Please contact me. Roy

$40 AUD Om 1 dag

4,9

(497 omdömen)

7,4

@Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """

$120 AUD Om 3 dagar

4,9

(277 omdömen)

7,1

@zebracaro

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

$70 AUD Om 3 dagar

4,9

(123 omdömen)

7,1

@bilalmaher053

hey, can u please share Excel file in chat? i will start work right now, thanks....

$100 AUD Om 1 dag

4,9

(330 omdömen)

7,2

@rajstk

Hello Cathylyoung, I can separate an excel file accurately and professionally as well as faster. We can discuss more details in message inbox. Best regards, Mayaraj Mahabub (Raj)

$50 AUD Om 0 dag

4,8

(221 omdömen)

7,3

@ESOLUTIONSSS

Hello Sir/Madam, It is my pleasure to be able to bid on your project. Really very much interested to have this project, if you permit. I am 100% confident that I can execute the project with good quality that will satisfy you. Thanks Sandeep Fully agree with your rate too so plz allow me to work for you.

$50 AUD Om 0 dag

4,9

(194 omdömen)

6,8

@sujonmax2

Hi, Can i help you to do the work.I've expert team handle the project and finished it very fast accurate. Please reply & and give me one Chance. awaiting for reply.. Regards sujon

$100 AUD Om 1 dag

5,0

(186 omdömen)

7,0

@hdlong66

Hello, I can separate your excel spreadsheet into smaller files with a maximum of 100 lines of data per file, and the dates don't overlap across two files. I’m ready to start immediately. Best regards, Hoang

$80 AUD Om 1 dag

5,0

(179 omdömen)

7,0

@yourjmr

Hi! This is Joseph from India. I have more than 15 years experience in Web Research & Excel field. I have read and understood the project details. I am very much interested to do this Excel task. I have depth knowledge in Excel. So I can easily handle this task. And check my reviews for your ready reference. I am waiting for your earliest reply. Thanks & Regards Joseph J

$60 AUD Om 1 dag

5,0

(390 omdömen)

6,8

@periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. I will automate the process and give you so, you can do it whenever required if needed. Within a couple of hours Willing to take up your project. Thank you, Regards.

$60 AUD Om 0 dag

5,0

(179 omdömen)

6,9

@mtanveer2012

I can separate 7,500 lines of data into other files by within next few hours, I am confident I can exceed your expectations. I can start to work in your project immediately. Please contact me, So we can discuss more over chat.

$200 AUD Om 0 dag