Find Jobs
Hire Freelancers

Excel VBA project

$30-250 USD

Suljettu
Julkaistu yli 5 vuotta sitten

$30-250 USD

Maksettu toimituksen yhteydessä
I need someone to write a routine to create a report based on defined rules using multiple excel files that will be received by e-mail. Report should be displayed as on the REPORT tab of attached file. This is made up of adding data from pivot tables from multiple data sources. All data to be received from 4 original files that will be received by e-mail each day at the same time with a unique file name + date. Each file will have a similar name to each tab in the attached file. CASH AT BANK INVENTORY ACCRUAL DATA CFL You need to save all of these tabs as individual tabs in one file and process them to give the result on the REPORT tab. Sample data is from a test environment of the system it will be produced from and does not relate to current business. This is just for you to understand the business requirement. I can provide additional info if required. Please advise estimated time to deliver such a project and cost. The report attached is only the first stage. Additional requirements to develop it further and other projects available if I am happy with the result
Projektin tunnus (ID): 17477898

Tietoa projektista

36 ehdotukset
Etäprojekti
Aktiivinen 6 vuotta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
36 freelancerit tarjoavat keskimäärin $169 USD tätä projektia
Käyttäjän avatar
Hello, I can help with you in your project Excel VBA project I have more than 5 years of experience in Data Processing, Excel, Software Architecture, Visual Basic, Visual Basic for Apps. We have worked on several similar projects before! We have worked on 370+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$200 USD 3 päivässä
4,9 (577 arvostelua)
8,5
8,5
Käyttäjän avatar
Hello! My name is Paris Pallas and just had the chance to read your project's brief. I'm a very experienced and skilled MS Excel developer and can write the necessary code to accomplish your tasks, thus bringing pivot tables data in the REPORT tab and fully automate this process. You're welcome to visit my portfolio and get an idea of who I am and what services I deliver to my clients. I'd like to clarify a few things with you whenever you have the time. I'm really interested in this project and I'm looking forward to working with you. I never ask for any payment in front. I claim the milestone release once the project is completed and my client is happy with the result. I'm looking forward to hearing from you. Sincerely, Paris Pallas
$190 USD 7 päivässä
5,0 (498 arvostelua)
8,4
8,4
Käyttäjän avatar
Hi there,I am Miljan,Excel VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$155 USD 3 päivässä
4,9 (201 arvostelua)
8,0
8,0
Käyttäjän avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
$200 USD 5 päivässä
5,0 (333 arvostelua)
7,4
7,4
Käyttäjän avatar
Dear client I understand the scope of work and I can set up a nice and easy spreadsheet for you for this. Kindly contact me for further details. Roy
$150 USD 3 päivässä
4,9 (494 arvostelua)
7,4
7,4
Käyttäjän avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. Willing to take up your project. Thank you, Regards.
$155 USD 3 päivässä
5,0 (184 arvostelua)
7,0
7,0
Käyttäjän avatar
I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for your project. I can complete this job within the necessary period. I have years of encounter in this work and can offer you my past taste work. I will be offering you with all my effort and capabilities. “Moving ahead, I can dedicate 35 hours/week for your job, and my daily hours are negotiable. I’m very empowered to offer my services for your job. Please you can get in touch with me instantly to discuss this place further.” I am mostly online at Yahoo Messenger, Google Talk . We can discuss there in details, if you are interested. I wish you'd give me this chance. Regards, Mohsan Ijaz
$222 USD 3 päivässä
5,0 (102 arvostelua)
6,7
6,7
Käyttäjän avatar
PhD in computer science having seven years of experience in Excel development and visual basics.
$250 USD 4 päivässä
4,7 (99 arvostelua)
6,5
6,5
Käyttäjän avatar
I know how to read emails from outlook, download files, compile them and create pivots all using VBA. I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana
$200 USD 3 päivässä
4,9 (106 arvostelua)
6,2
6,2
Käyttäjän avatar
Looking through your provided file, I will easily be able to generate the summary report. All I will need from you, is the Business Rules for the summaries (E.G. Exactly what values in which cells are combined to obtain the summary value). Some of these seem like just replicating values from the spreadsheets, but confirmation of that will help. With this information, I will create a simple algorithm that will sift through the spreadsheets and summarize the data in your provided format. It should take less than 1 day to complete the initial draft, then a day for you to review and advise any errors, then one more day to finalize.
$150 USD 5 päivässä
5,0 (47 arvostelua)
6,2
6,2
Käyttäjän avatar
I have expertise in VBA, advanced excel and data processing. You can go through my previous project in which i have developed many VBA automation tools. Quality work and client satisfaction is my first priority. I offer my clients to pay me only if they are satisfied with the work otherwise not. What you will get: You will get high quality work with low cost Please feel free to contact me for further discussion on the project. Looking forward to work with you.
$90 USD 1 päivässä
4,9 (51 arvostelua)
5,9
5,9
Käyttäjän avatar
Good knowledge on Excel VBA to build Excel macro to automation data sheet and management and processing. 15+ years of experience on Computer Language and Digital Electronics.
$250 USD 3 päivässä
5,0 (22 arvostelua)
5,7
5,7
Käyttäjän avatar
- Went through the description and the file having tabs like REPORT CASH AT BANK INVENTORY INV BY BANK CFL..... - From the four files have the tabs consolidated - By click of the button generate the report in the format of REPORT tab. - Have done similar banking transcations consolidaion across multiple sheets (Multi currencied transactions) can showcase. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - 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., - 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 projects done - https://www.freelancer.com/u/satishtl Sample HighComplex Projects using Macros: (via Freelancer) - Complex Data anlaysis and graphing - Using Surface, Scatter Dynamically setting axis values, legennd colors(Excel 2013 to Excel 2016) - 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 +..
$160 USD 5 päivässä
4,7 (54 arvostelua)
6,1
6,1
Käyttäjän avatar
hi good day! I've been working with diff client for almost 7yrs now. and my primary skill and task is to enhance their financial report template to have an accurate result. I am ms excel certified and I can deliver this work to you accurately. Chat me anytime to discuss this project. Please accept me to this job. Thanks
$100 USD 2 päivässä
4,7 (78 arvostelua)
5,4
5,4
Käyttäjän avatar
i have good command over ms excel especially pivot table, charts, advance formulas, formatting, etc. Please review my profile and inbox me,Thanks
$250 USD 3 päivässä
4,9 (35 arvostelua)
5,0
5,0
Käyttäjän avatar
Greetings for the Day!!! I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,...Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details .Thank you :)
$166 USD 5 päivässä
5,0 (65 arvostelua)
5,1
5,1
Käyttäjän avatar
Hi i saw your description and attachment, and i am sure i can handle your request. I have 10+ years of experience in Advance Excel, VBA, Macros and other office integration development
$111 USD 3 päivässä
5,0 (10 arvostelua)
4,2
4,2
Käyttäjän avatar
Hi I am expertise in Excel VBA.I can do this job ontime with 100% result. Expected time is 3 days and th e cost is 100$
$111 USD 3 päivässä
5,0 (14 arvostelua)
3,6
3,6
Käyttäjän avatar
Hi, I've been in excel vba macro for 3 years and currently creating company tools for users reporting. Willing to help you with your project, just let me know and we can discuss it further. Thanks, Marlou
$166 USD 5 päivässä
2,3 (6 arvostelua)
4,1
4,1
Käyttäjän avatar
hi , I have good knowledge in vba and I have delivered many projects successfully. I have multiple options to do this work.
$138 USD 7 päivässä
5,0 (2 arvostelua)
1,4
1,4

Tietoja asiakkaasta

Maan MONACO lippu
Monaco
0,0
0
Liittynyt heinäk. 31, 2018

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.