Find Jobs
Hire Freelancers

building excel VBA - Copying excel data from closed excel file from multiple sources

$30-250 USD

Closed
Posted about 7 years ago

$30-250 USD

Paid on delivery
We are in need of building an excel dashboard which can pull data from multiple excel sheets in multiple excel files, located in multiple data locations on a network. Every time we pull the data, the old data should be deleted. The excel file that you will build should include one page wherein the file locations can be chosen, and include a buttons for every data-pull to execute the VBA.
Project ID: 13501243

About the project

33 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
33 freelancers are bidding on average $165 USD for this job
User Avatar
Hello I am Excel Expert and VBA Programmer I can write for you desirable macros, which fill , clear remaining data, import new one from separately mentioned folder paths on another links, and update file with this data Everything can be assigned to one magic button If interested, let me know Thanks & Regards
$200 USD in 3 days
5.0 (199 reviews)
8.2
8.2
User 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
$250 USD in 2 days
4.9 (346 reviews)
8.0
8.0
User Avatar
Hi, I am good at Excel and building useful scripts for my clients. I just checked the description you have provided regarding the project and would be a pleasure to assist you on your project. I will work with full dedication to give you the best output within the desired timeframe. I look forward to hear from you. Looking forward to discuss in the chat and a long term relationship ahead. Wishing you a great day ahead. https://www.freelancer.com/u/cgullapalli.html#/profile-reviews Regards, Chandra
$100 USD in 1 day
5.0 (919 reviews)
8.1
8.1
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have an Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets filled with formulas and VBA code. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. I am online from 3pm to 11pm Mon-Fri and 8am to 11pm Sat-Sun (GMT+3). If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$140 USD in 7 days
4.9 (250 reviews)
7.6
7.6
User Avatar
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India
$250 USD in 5 days
4.8 (297 reviews)
7.1
7.1
User Avatar
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to complete your project. Please contact me to discuss the details. Please have a look at some Excel projects I've done: https://www.freelancer.com.au/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com.au/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
$150 USD in 3 days
4.8 (172 reviews)
7.1
7.1
User Avatar
i can do it for you quickly and exactly
$100 USD in 3 days
4.9 (116 reviews)
7.1
7.1
User Avatar
Hello, I am highly skilled in Excel VBA and can develop the required dashboard within 4 days. Please discuss exact details via chat. Thank you, Usman
$200 USD in 4 days
5.0 (70 reviews)
6.7
6.7
User Avatar
Hi: Please share the sample files. This will allow me understand what needs to be pulled from the other source and in which format. Please note that over 80% of my completed projects are related to Excel and Macro. Moreover, I have ~100% completion rate and ~5-star feedback on projects. Please connect with me to discuss your requirements in detail.
$150 USD in 5 days
4.9 (168 reviews)
7.0
7.0
User Avatar
Hi, I have more than 14 years of Excel/VBA exp. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$150 USD in 3 days
4.9 (115 reviews)
6.2
6.2
User Avatar
I am a professional freelancer having expertise in MS Excel and I can complete your task effectively and efficiently in a timely manner. Portfolio: https://www.freelancer.in/u/KavTan.html
$400 USD in 7 days
4.8 (52 reviews)
6.0
6.0
User Avatar
- Can pull the data from multiple excel files, and multiple locations and get them consolidated into the single format for reporting purpose. - Can provide a button, on click will pull the information from the respective files. - 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., - 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. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables. - University, US - Scoring the answer sheets based on keyword and number of occurences.
$125 USD in 4 days
4.6 (49 reviews)
6.0
6.0
User Avatar
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I have great experience in any kind of data manipulation with Excel/VBA. I can start working on the project immediately and complete the job within two, maybe three days. If you open chat I can send you a working mockup immediately containing the sheet where the file locations can be chosen. Regards
$98 USD in 3 days
4.9 (64 reviews)
5.7
5.7
User Avatar
Hi I’m an Access/VBA programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$250 USD in 3 days
4.7 (18 reviews)
5.3
5.3
User Avatar
Hi I’m an expert in MS technologies (SQL server, VBA and .Net) I have been working in software development for the last 20 years I have a lot of experience in desktop and web development I’m also available 24 x 7 Regards Carlos
$155 USD in 10 days
4.9 (26 reviews)
4.9
4.9
User Avatar
Hi, i'm a professional C# programmer, and i can provide you with a C# program to do the pulling task efficiently instead of the Excel VBA, please let me know if you are interested, thanks.
$150 USD in 3 days
5.0 (13 reviews)
4.5
4.5
User Avatar
Hey there, From the sounds of it, you need an Excel expert who can write optimized formulas, VBA code and analyze data to prepare dashboard for you. Is that sounds about right? I have an extensive knowledge of Excel included VBA. I have also a strong database and analytic background that could be a profit in your project. I've successfuly completed many Excel projects for random clients. Always on time and budget. What is your favorite way to comunicate? Is there any posibility to get more details about this project? Best regards, Rafael Ps. This could be one of my first projects here, so give me the chance to proof that i'm really good business partner. I'm sure that i wont let you down.
$55 USD in 10 days
4.9 (16 reviews)
4.5
4.5
User Avatar
I have 7 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
$166 USD in 3 days
5.0 (48 reviews)
4.6
4.6
User Avatar
Hello Sir, I am shahid from kashmir. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well.I'm interested in your project. Please send me a message so that we can discuss more. I have 8 years of experience in , Data entry, Linkedin, Lead generation , Google Research Expert,Web scraping,Leads, Web Search, Data Mining,Internet research. My key skills are: Research,Data entry,E mails marketing,Python Email developer, software architecture and Scrapping expert with 8 years of experience. Linkedin API developer. . Using,Leads ,Web Search ,Machine Learning,Linkedin, ,Web Services ,Internet Researc,Data mining,Web scrapping, Find contacts,Data Processing, Data Entry, Excel, Leads, Web Search, DataMining,Linkedin,MicrosoftOffice,Emailhandling,CProgramming,C++Programming,Linux,PHP,MYSQL,Java,Javascript,WebsiteDesign,GraphicDesign,CSS,Research,Wordpress,Magento ,Matlab and Mathematica .  I am a highly skilled  provider seeking an opportunity to leverage my expertise and demonstrate my high level of technical an administrative skills,I have completed 40+ projects in web Application,I also work on Data entry, Linkedin, Lead generation , Google Research Expert,Web scraping,Leads, Web Search, Data Mining,Internet research. I can achieve the results that you are asking for. Please check out my portfolio and my past work on my profile through reviews,Looking forward from your end. Thanks
$30 USD in 5 days
4.5 (8 reviews)
4.6
4.6
User Avatar
Hi there, I'm an Excel expert with rich experience of Excel VBA programming. I can complete the work well with good quality. Feel free to contact me and discuss more details. Best Regards, VL
$100 USD in 3 days
4.9 (11 reviews)
3.7
3.7

About the client

Flag of THAILAND
bangkok, Thailand
0.0
0
Member since Sep 13, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.