Find Jobs
Hire Freelancers

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

$30-250 USD

В роботі
Опублікований almost 6 years ago

$30-250 USD

Оплачується при отриманні
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”.
ID проекту: 16855368

Про проект

33 пропозицій(-ї)
Дистанційний проект
Активність 6 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
33 фрілансерів(-и) готові виконати цю роботу у середньому за $118 USD
Аватарка користувача
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 за 3 дні(-в)
4,9 (393 відгуки(-ів))
8,1
8,1
Аватарка користувача
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 за 0 день
5,0 (951 відгуки(-ів))
8,1
8,1
Аватарка користувача
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 за 1 день
4,9 (454 відгуки(-ів))
7,5
7,5
Аватарка користувача
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 за 1 день
4,9 (403 відгуки(-ів))
7,6
7,6
Аватарка користувача
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 за 3 дні(-в)
4,9 (280 відгуки(-ів))
7,7
7,7
Аватарка користувача
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 за 2 дні(-в)
5,0 (257 відгуки(-ів))
7,4
7,4
Аватарка користувача
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 за 1 день
5,0 (276 відгуки(-ів))
7,1
7,1
Аватарка користувача
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 за 3 дні(-в)
5,0 (130 відгуки(-ів))
6,5
6,5
Аватарка користувача
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 за 1 день
5,0 (111 відгуки(-ів))
6,3
6,3
Аватарка користувача
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 за 3 дні(-в)
4,8 (116 відгуки(-ів))
6,1
6,1
Аватарка користувача
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 за 3 дні(-в)
5,0 (83 відгуки(-ів))
5,8
5,8
Аватарка користувача
- 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 за 3 дні(-в)
4,7 (52 відгуки(-ів))
6,0
6,0
Аватарка користувача
IMacro am very able to create the macro as per your requirement.
$99 USD за 2 дні(-в)
4,6 (55 відгуки(-ів))
5,7
5,7
Аватарка користувача
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 за 3 дні(-в)
5,0 (29 відгуки(-ів))
5,1
5,1
Аватарка користувача
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 за 3 дні(-в)
4,5 (35 відгуки(-ів))
5,3
5,3
Аватарка користувача
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 за 3 дні(-в)
5,0 (63 відгуки(-ів))
5,1
5,1
Аватарка користувача
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 за 4 дні(-в)
4,9 (28 відгуки(-ів))
4,8
4,8
Аватарка користувача
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 за 2 дні(-в)
5,0 (11 відгуки(-ів))
4,0
4,0
Аватарка користувача
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 за 3 дні(-в)
4,7 (32 відгуки(-ів))
4,5
4,5
Аватарка користувача
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 за 3 дні(-в)
4,4 (48 відгуки(-ів))
4,6
4,6

Про клієнта

Прапор UNITED STATES
Holland, United States
0,0
0
На сайті з квіт. 29, 2018

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.