Automatically update an excel file pulling information from several csv file
$30-250 AUD
货到付款
- 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.
项目ID: #9749353
关于项目
有46名威客正在参与此工作的竞标,均价$104/小时
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 更多
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
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 更多
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 更多
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 更多
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 更多
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
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.
Hello, this is something I could do very quick for you. Please contact me for more information. Thank you!
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.
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 更多
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 更多
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 更多
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 更多
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 更多
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