Automatically update an excel file pulling information from several csv file

Cerrado Publicado Feb 24, 2016 Pagado a la entrega
Cerrado Pagado a la entrega

- 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 para aplicaciones

Nº del proyecto: #9749353

Sobre el proyecto

46 propuestas Proyecto remoto Activo Apr 1, 2016

46 freelancers están ofertando un promedio de $104 por este trabajo

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 Más

$85 AUD en 5 días
(212 comentarios)
7.4
zebracaro

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

$100 AUD en 2 días
(112 comentarios)
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 Más

$90 AUD en 2 días
(172 comentarios)
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 en 1 día
(71 comentarios)
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 Más

$100 AUD en 3 días
(189 comentarios)
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 Más

$105 AUD en 3 días
(113 comentarios)
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 Más

$66 AUD en 2 días
(121 comentarios)
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 Más

$120 AUD en 5 días
(65 comentarios)
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 en 2 días
(46 comentarios)
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 en 3 días
(94 comentarios)
6.0
vlayausa

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

$86 AUD en 3 días
(132 comentarios)
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 en 3 días
(71 comentarios)
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 Más

$111 AUD en 3 días
(46 comentarios)
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 Más

$111 AUD en 1 día
(16 comentarios)
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 Más

$83 AUD en 3 días
(51 comentarios)
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 Más

$100 AUD en 3 días
(12 comentarios)
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 Más

$100 AUD en 1 día
(8 comentarios)
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 Más

$120 AUD en 3 días
(3 comentarios)
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 Más

$222 AUD en 1 día
(3 comentarios)
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 en 3 días
(1 comentario)
1.2