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 Excel Visual Basic的应用程式

项目ID: #9749353

关于项目

46个方案 远程项目 活跃的7 年前

有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

$100AUD 在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 更多

$111AUD 在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 更多

$100AUD 在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 更多

$222AUD 在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