Find Jobs
Hire Freelancers

Excel Macro 050118 - 01/05/2018 20:30 EDT

$30-250 USD

In Progress
Posted about 6 years ago

$30-250 USD

Paid on delivery
All functionality to reside within an Excel workbook and be fully unprotected for future use by others. All code needs to be fully notated to describe functionality, etc. No proprietary or exotic applications or maintenance restrictions to be used. No functionality, additional prompts, etc. should be added other than what is requested. Need to add, only additional code, to an already existing and functioning macro. This workbook to be provided to programmer. The new code should copy data from Excel workbooks, 1 or 100 workbooks that exist in a folder called “Folders” on a Windows 7 standard desktop. Other workbooks exist within this folder but only data within the Excel workbooks should be copied. These workbooks are all of the same type and construction, i.e. only one worksheet, have the same fields, same order, etc. These worksheets are ~100 rows each and columns span from A to BCD, however many columns that is. The data within these files to be copied to the first worksheet in the macro workbook starting in row 2. The data in each subsequent workbook to be copied immediately below the previous set of data in alphabetical order based on the data in column 1. Attached is a sample file. Also existing Macro to be renamed simply “Macro”.
Project ID: 16855368

About the project

33 proposals
Remote project
Active 6 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 $118 USD for this job
User Avatar
Greetings of the day! I am the best fit to your requested requirement. I can help you in Excel Macro. My Expertise & Experience: I am skilled in Excel, Software Architecture, VB.NET, Visual Basic, Visual Basic for Apps. I would love to work with you on this project. Carrying total experience of 6.5 years. I can assure you, you won't disappointed with class of the work I produce. I can start the work on the go as per your need! Communication: I will be available on the freelancer.com chat 18 hours in the day. (FLEXIBLE WITH TIMINGS IN CASE OF THE NEED) I am just a message away in case of any queries.
$155 USD in 3 days
4.9 (393 reviews)
8.1
8.1
User Avatar
Hi, I can transfer the data from multiple sheets to one sheet. Looking forward to work on the project and provide quick turn around. Please share sample to file to work on. I have created similar type of programs to transfer the data from different workbooks to single workbook. -Chandra
$50 USD in 0 day
5.0 (951 reviews)
8.1
8.1
User Avatar
Hello VINCE , I have read your project description and understood your requirement. I have 5 years experience in Excel VBA programming and can complete task within time with 100% accuracy.I am very responsible towards our clients. I know my client needs and importance. Skills : Excel, Macros,VBA,Web scraping,Web Search, Data entry, Copy typing, Transcription works,Wordpress,Megneto,Woocommerce,Shopify,Prestashop etc With Regards, Bhaskar.
$30 USD in 1 day
4.9 (454 reviews)
7.5
7.5
User Avatar
Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$100 USD in 1 day
4.9 (403 reviews)
7.6
7.6
User Avatar
Hello! My name's Paris Pallas and I'm an experienced Excel developer willing to help you. Having developed over 220 projects in a 5-year period successfully I'm very confident I can deal with your project's challenges. I see that you are looking for a macro update to retrieve content from other Workbooks located in a specific folder. It's something I've done many times and know how to deal with it. There is no attachment, so please send it to me. I'd like to have the whole picture before proceeding. I can deliver within 1-3 days. Paris
$100 USD in 3 days
4.9 (280 reviews)
7.7
7.7
User Avatar
Hi, I am an Excel macro expert and have completed more than 300 Excel automation projects on freelancer. Kindly provide sample data file and macro file to work on. Regards, Arul
$100 USD in 2 days
5.0 (257 reviews)
7.4
7.4
User 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
$100 USD in 1 day
5.0 (276 reviews)
7.1
7.1
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.
$155 USD in 3 days
5.0 (130 reviews)
6.5
6.5
User Avatar
I am proficient with Microsoft excel and macro/VBA development, by your specification what you are asking seems really achievable, if you are interested feel free to message me, I would love to take a look at the workbook, looking forward to chat further for a quick turnaround solution and work on your project.
$50 USD in 1 day
5.0 (111 reviews)
6.3
6.3
User Avatar
Hello. I have rich experiences in Excel VBA and Macro. I have read your project description carefully and i'm interested in your project. Contact me please. Thanks.
$155 USD in 3 days
4.8 (116 reviews)
6.1
6.1
User Avatar
Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can develop the best script to mt your needs in the least time starting right now. I will do all and extra to ensure that you won't regret giving me this project. Please, message me and let us discuss more about your project. Thanks
$70 USD in 3 days
5.0 (83 reviews)
5.8
5.8
User Avatar
- Can implement the code to have the 100 workbooks data being read from the "Folders" directory. - Data from each workbook could be copied to the first worksheet from Row2. - Subsequent workbook data would follow from the next row in the first sheet. - Have done similar data consolidation, comparison of column data by click of a button. - As the attachement is not found can disucss more once you send the sheet. My Skills: - 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., - 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 + more....
$80 USD in 3 days
4.7 (52 reviews)
6.0
6.0
User Avatar
IMacro am very able to create the macro as per your requirement.
$99 USD in 2 days
4.6 (55 reviews)
5.7
5.7
User Avatar
I am an Excel developer with over 15 years professional experience writing custom VBA solutions and I am highly experienced in automation of data processing and have developed multuple similar solutions throughout my career. After reading the job I hope you don't mind if I ask you some questions - 1. Once the data has been read into the 'main' file would you like the files in the folder moved to an archive / processed location? 2. Is the first workbook to also be sorted alphabetically? Or is it only the subsequent workbooks? 3. Is there a particular order that the books should be processed in? If so, how is this determined (e.g. it may be obvious based on file name, date created / modified etc.)? 4. You mentioned other workbooks exist in the folder, but only Excel workbooks should be copied - are you able to clarify this a little further (e.g. is it that other files exist and only Excel files copied, or is it that other workbooks exist but only workbooks with the same structure should be copied)? All of the above is achievable - however I like to work with a clear spec to meet expectations and I would love to work with you on this project
$240 USD in 3 days
5.0 (29 reviews)
5.1
5.1
User Avatar
Hello Sir, I am experienced programmer of VBA with in office applications. I've done similar tasks already. I'll make program easy enough to make you understand along with comments so you can easily change in future according to requirements. Also i'll try my best that there are no required restrictions or set of procedure to be followed. Kindly text me if you are interested in my bid. Thanks
$150 USD in 3 days
4.5 (35 reviews)
5.3
5.3
User 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.
$83 USD in 3 days
5.0 (63 reviews)
5.1
5.1
User Avatar
I have done very silar work of copying data from multie sheets to a single sheet. I just need to enhance it to open a workbook everytime and read. Give me the job and rest assured it is done.
$97 USD in 4 days
4.9 (28 reviews)
4.8
4.8
User Avatar
Dear Hiring Manager, I have worked on similar projects and would like to work on your project. My expertise includes, but not limited to: Macros, Web Scraping, Customized Ribbon Buttons, Pivot Tables, Formulas, Data extraction from Outlook, PDF, Access, etc. Looking forward to hear from you. Regards Chintu
$72 USD in 2 days
5.0 (11 reviews)
4.0
4.0
User Avatar
Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now
$100 USD in 3 days
4.7 (32 reviews)
4.5
4.5
User Avatar
Hi, I have seen your proposal. I am an excel expert with very good knowledge of VBA. I think I can do this job very efficiently. Kindly come on chat for more details. Thank you.
$111 USD in 3 days
4.4 (48 reviews)
4.6
4.6

About the client

Flag of UNITED STATES
Holland, United States
0.0
0
Member since Apr 29, 2018

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.