Find Jobs
Hire Freelancers

Excel Macro Bulk Importing Multiple External Files into Template

$10-60 USD

Tamamlandı
İlan edilme: yaklaşık 7 yıl önce

$10-60 USD

Teslimde ödenir
This project is for Microsoft Excel. Deadline for deliver is Sunday April 30th. 9 files, 11 sheets. Formats will always remain the same. This macro will be for multiple runs, I will be using it weekly and sometimes twice a week. 1) Macro will allow to browse to each file path. Can run Macro for 1 file or all files at once. 2) Symbols will upload from each file one by one with the data attached to its row. 3) Sometimes not all files will be selected, macro will need to run in this situation with 1-9 files. 4) All files will remain in this format. 5) Once all symbols from each file is uploaded, they will match and transpose onto one row (see template). 6) I provide the Template format. *Can run Macro for 1 file or multiple files. Reason 1: Sometimes files take too long to import. Reason 2: Sometime user dose not want to import all files (in case on error with 1 file) - Files contain 1 common element, a symbols column. - Each file has the same process, upload symbols with the required columns from the external file into the correct columns into the Matrix Template. Contact me for quick hire. Looking for quick delivery. How fast can you write it ?
Proje No: 13861834

Proje hakkında

19 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 7 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
Seçilen:
Kullanıcı Avatarı
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene PS. Windows only.
$60 USD 1 gün içinde
5,0 (264 değerlendirme)
6,5
6,5
19 freelancer bu proje için ortalama $69 USD teklif veriyor
Kullanıcı Avatarı
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$100 USD 1 gün içinde
4,9 (385 değerlendirme)
8,1
8,1
Kullanıcı Avatarı
Hi I am Excel Expert and VBA Developer Your description was pretty clear and after seeing template file may would have few questions Time need will be 1 day , approx , maybe just couple of hours So, if interested, contact me Thanks & Regards
$56 USD 1 gün içinde
5,0 (204 değerlendirme)
8,2
8,2
Kullanıcı Avatarı
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I'm an expert in Excel macros. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav
$111 USD 1 gün içinde
4,9 (180 değerlendirme)
6,6
6,6
Kullanıcı Avatarı
- Can deliver by Apr30 - Can make the program work for 1 file or the files in the specific folder you choose. - I dont see the template and the source format attached, but can the symbols from the source consolidated into the target files. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Data extraction using API. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on recent projects. Sample HighComplex Projects using Macros:(via Freelancer) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables. - Stocks Portfolio - Showing client portfolio stocks with various indicators, Momentum indicators based on portfolio. - University, US - Scoring the answer sheets based on keyword and number of occurences.
$100 USD 3 gün içinde
4,7 (53 değerlendirme)
6,1
6,1
Kullanıcı Avatarı
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. You asked two questions - 1. Can run Macro for 1 file or multiple files? Ans: Yes, it is possible to run the macro for 1 file or multiple files. 2. How fast can you write it ? Ans: I can develop the macro within 1 day. I have excellent knowledge and experience of Importing Data from Multiple Files, Manipulating Data of Multiple Sheets, Using Advanced Formulas, Critical Programming and Creating Reports. I have done same job before. So, I can do this job nicely. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio Ready to start please reply soon. Thanks, Virendra
$60 USD 1 gün içinde
4,8 (98 değerlendirme)
5,8
5,8
Kullanıcı Avatarı
I can do this task in a couple of hours as i have the experience in writing similar macros. I have the expertise in Excel VBA and can do this task, as per requirements, quickly and accurately. Ready to start work immediately.
$40 USD 1 gün içinde
4,6 (69 değerlendirme)
5,4
5,4
Kullanıcı Avatarı
Symbols upload? where to upload? Another are okay I think. I've finished some macro projects. I'm waiting your reply to discuss further, Thanks
$50 USD 2 gün içinde
5,0 (46 değerlendirme)
4,7
4,7
Kullanıcı Avatarı
Hi, Excel automation is my expertise. I've been coding vba for 6 years now. I can deliver fast and with high quality. Thanks and best regards, John
$45 USD 1 gün içinde
5,0 (17 değerlendirme)
3,8
3,8
Kullanıcı Avatarı
Hi, I am an excel and vba specialist, I understand what you want and I can finish your project in 2 days, 30/04/2017 morning maximum.
$66 USD 3 gün içinde
4,9 (6 değerlendirme)
2,7
2,7
Kullanıcı Avatarı
We are interested in doing a FREE demo for you. We have done similar work to your project title and in order for us to proceed we would need to talk over your project as we have a few questions. Our FREE demo is completely free and does show you what you could expect when you hire us. Click on the chat icon below and let's get started.
$60 USD 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
I've already done your spreadsheet, I'm just waiting for your confirmation to send you ☺️
$166 USD 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
do this for my day job
$25 USD 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
I am a professional Aerospace Engineer. I am detail oriented and can complete your project within your specifications. I am new to the site and just want to make a little money on the side for supplemental income. Please consider me for your project and I will begin when you are ready. Check out my qualifications and Have a fantastic day!
$40 USD 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0

Müşteri hakkında

   CANADA bayrağı
Toronto, Canada
5,0
17
Ödeme yöntemi onaylandı
Şub 26, 2014 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.