Automatically update an excel file pulling information from several csv file

終了済み 投稿 Feb 24, 2016 着払い
終了済み 着払い

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

AutoHotkey エクセル アプリ用ビジュアルベーシック

プロジェクトID: #9749353

プロジェクトについて

46個の提案 リモートプロジェクト アクティブ Apr 1, 2016

46人のフリーランサーが、平均$104 で、この仕事に入札しています。

paris2785

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 pr もっと

$85 AUD 5日以内
(212件のレビュー)
7.4
zebracaro

I can do it for you quickly and exactly by vba .

$100 AUD 2日以内
(112件のレビュー)
7.0
cugamelover

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 もっと

$90 AUD 2日以内
(172件のレビュー)
7.0
maverick44000

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 1日以内
(71件のレビュー)
6.7
danielgpratidya

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 gr もっと

$100 AUD 3日以内
(189件のレビュー)
6.6
rohitpithisaria

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 もっと

$105 AUD 3日以内
(113件のレビュー)
6.5
nagyzoltan68

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 req もっと

$66 AUD 2日以内
(121件のレビュー)
6.4
Vasilchenko

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 re もっと

$120 AUD 5日以内
(65件のレビュー)
6.3
RRajeshR

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 2日以内
(46件のレビュー)
6.1
macroPOL

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 3日以内
(94件のレビュー)
6.0
vlayausa

Hello, this is something I could do very quick for you. Please contact me for more information. Thank you!

$86 AUD 3日以内
(132件のレビュー)
5.8
renesontiongson

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 3日以内
(71件のレビュー)
5.5
abhinovpankaj

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 va もっと

$111 AUD 3日以内
(46件のレビュー)
5.4
DorianGrim

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 もっと

$111 AUD 1日以内
(16件のレビュー)
5.0
prabakarm23

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 Ou もっと

$83 AUD 3日以内
(51件のレビュー)
4.7
Madaky01

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 もっと

$100 AUD 3日以内
(12件のレビュー)
4.2
AmmarHafeez

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 もっと

$100 AUD 1日以内
(8件のレビュー)
3.1
asi562da7b98b2b8

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 もっと

$120 AUD 3日以内
(3件のレビュー)
3.1
TianaKay

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 もっと

$222 AUD 1日以内
(3件のレビュー)
3.4
DanielCtin

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 3日以内
(レビュー1件)
1.2