Find Jobs
Hire Freelancers

Automatically update an excel file pulling information from several csv file

$30-250 AUD

Closed
Posted about 8 years ago

$30-250 AUD

Paid on delivery
- I am a finance professional who has to update an excel file (named "[login to view URL]") every day with banking transactions from tens of bank accounts. Each bank account has an unique account number. They are represented with a sheet in [login to view URL] - Everyday I have to download a few csv file from the online bank website and then copy the transactions contain in these csv file to [login to view URL] - The csv files contain 5 column of data: Date/ Description/ Positive figure/ Negative/ Bank account number. The csv files are saved in a fixed folder everyday, so are the [login to view URL] file. - I visualize myself openning [login to view URL] and press a combination of hot key, those transaction in csv files will be automatically added into different worksheet corresponding to different bank accounts.
Project ID: 9749353

About the project

46 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
46 freelancers are bidding on average $104 AUD for this job
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$85 AUD in 5 days
4.9 (212 reviews)
7.4
7.4
User Avatar
I can do it for you quickly and exactly by vba .
$100 AUD in 2 days
4.9 (112 reviews)
7.0
7.0
User Avatar
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I've done a lot of similar work. I could send you samples of my work if you wish. Please see reviews on my profile. It would be my pleasure to do your project. Please let me know the details. Please have a look at some Excel projects I've done: https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
$90 AUD in 2 days
4.8 (172 reviews)
7.0
7.0
User Avatar
Hi Sir, Please share one of the sheets so I may take a look. I have done exact same work before and I shall be able to do it within 2 days. Please discuss before awarding the work. Thank you, Usman
$100 AUD in 1 day
5.0 (71 reviews)
6.7
6.7
User Avatar
Hi, Very well explained, thanks. I have built so many similar excel automation to extract data from csv and place them to corresponding cells in an excel report. Feel free to check my profile page and it'd be great if you can send me the xls template and the csv sample for me to work on a mockup sample. Cheers, Daniel
$100 AUD in 3 days
5.0 (189 reviews)
6.6
6.6
User Avatar
Hello I am an excel expert and would like to bid on the project posted by you. I have completed more than 100 projects in excel. FYI: Freelancers are not authorized to send any attachments to the employer before we receive any personal message from the client. I request you to kindly initiate the conversion so that I can send examples of my work. Rgds Rohit Pithisaria
$105 AUD in 3 days
4.9 (113 reviews)
6.5
6.5
User Avatar
Hello , I would like to work on your project. I have great experience using excel, formulas, user defined functions and macros / vba. I intend to create 1 macro that will copy data from csv files into excel file as required, Provide please details in PM. Thank you. Regards
$66 AUD in 2 days
5.0 (121 reviews)
6.4
6.4
User Avatar
Hello I can do this work via Delphi application or via Excel macros. There are not differense for me which way we select. The main problem for me will time difference between our countries. So, If time or project realization are not very important for you I am glad to do this project for you.
$120 AUD in 5 days
4.9 (65 reviews)
6.3
6.3
User Avatar
HI, I am interested to work in your task.I can write a Excel VBA or JAVA code to copy the data from CSV files to master excel file. Please contact me to start the work. Thanks, Rajesh
$80 AUD in 2 days
5.0 (46 reviews)
6.1
6.1
User Avatar
Hello, I am Excel and VBA expert. I can complete this project. Can I view the files? Please note that I have 100% completion rate and 5-star feedback on projects.
$100 AUD in 3 days
5.0 (94 reviews)
6.0
6.0
User Avatar
Hello, this is something I could do very quick for you. Please contact me for more information. Thank you!
$86 AUD in 3 days
4.9 (132 reviews)
5.8
5.8
User Avatar
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.
$80 AUD in 3 days
4.8 (71 reviews)
5.5
5.5
User Avatar
Hello, I have been working as freelancer since last ~ 2.5 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$111 AUD in 3 days
4.9 (46 reviews)
5.4
5.4
User Avatar
Hi, This is no task for AutoHotkey, but more a combination of Microsoft Access, Excel and VBA of the two, since the source file has the same name. We could introduce AHK also, but it would complicate things. I can help you with this, and it should not take more than a day, using the above mentioned. I am looking forward to work with you, Dorian
$111 AUD in 1 day
5.0 (16 reviews)
5.0
5.0
User Avatar
Greetings for the Day!!! i have 6 years of experience in Data entry and typing , Power Shell Script,.NET,Excel macro, VB script and VB application creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases.
$83 AUD in 3 days
5.0 (51 reviews)
4.7
4.7
User Avatar
Hello. I can create an app that download, open, read and write data from a csv to another etc. I'll just need a good guide of each step. Waiting your pm to clarify the things. After you give me your details i can build a trial app for you to test, for free.
$100 AUD in 3 days
5.0 (12 reviews)
4.2
4.2
User Avatar
Hi... I am a programming expert and have done projects like this involving csv and excel using python programming language.. The task is simple you just have to give the csv files and xls and all data will be adjusted automatically by the application.. Looking forward to work with you...
$100 AUD in 1 day
5.0 (8 reviews)
3.1
3.1
User Avatar
Hello, I am a very experience expert level Excel/VBA programmer with experience in financial organisations worldwide. Having read your scope I am confident I could produce a hotkey based macro that would import any file from a specific folder into a worksheet and summarise as necessary on your main bank worksheet. I've completed similar jobs like this in my work history. Also I am based in Australia which will make communications easier. Let me know if you need any more information to proceed. Thanks, Adam
$120 AUD in 3 days
4.7 (3 reviews)
3.1
3.1
User Avatar
Local Australian Excel Guru with extensive data manipulation/data collection/scraping experience. Ive worked as an operations analyst at some of the biggest ecommerce companies in aus/globally (eBay, Groupon) creating automated solutions in excel to drive optimisation. Can get this done for you quickly and accurately.
$222 AUD in 1 day
3.9 (3 reviews)
3.4
3.4
User Avatar
Hello, I already have the code for this, few small changes according to your needs and it's ready. Looking forward to hear from you, Daniel
$200 AUD in 3 days
5.0 (1 review)
1.2
1.2

About the client

Flag of AUSTRALIA
Australia
0.0
0
Member since Feb 24, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.