1) Combine spreadsheets based on common file name attributes (add new data to existing sheets via copy paste).
2) Create new spreadsheet with all data on one tab, and pivot table on new tab.
3) Create 3rd tab with a copy paste of pivot table data so that 3rd sheet is static, not pivot table dynamic.
4) A GUI interface is needed to allow the user to select input and out put folders.
5) Macro must retain directory path after each time user changes it so that input/output directory paths can be reused by user if desired.
Hi Sir. Your project description doesn't contain sample files. Please, can you pm me with your files. If you have already chatted with somebody please copy and paste the conversation if you feel difficult to explain to Mai multe
18 freelanceri licitează în medie 133$ pentru acest proiect
I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid Mai multe
Hello there, I have done lot of similar work. Can you share your template? if you have. I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over Mai multe
Dear client I have previously carried out a number of projects in excel using macros. Kindly contact me for further details. Roy
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Willing to take up your project. Thank you, Regards.
Hello Sir, I went thru the description Kindly send me the details, I can start it by today Here is the link for the similar project previously I did [login to view URL]!AtCZd2sWox0MsmvWr-ibOMHTqQKG I loo Mai multe
Greetings! I am full time excel freelancer, ready to create excel template as you mentioned in project description. You may check my latest portfolio on below link: https://www.freelancer.com/u/gsanggara https: Mai multe
Hi Good Day! I can help you to complete your excel works in 1-2 days. I am a vba macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. I created different template and t Mai multe
Hello. I have good skills in Excel/VBA. I'm interest to your project. But i have some questions. I understood with 4) and 5) and i can do it perfectly. But i 'm not understand with 1), 2) and 3). Can you explain Mai multe
Hi I am "VBA Developer". Expertised in Web Scraping & VBA Macros.. i can do any excel automation tasks, bulk email handling using outlook,File Conversion i can "SCRAPE" any website either static or dynamic also.. Mai multe
My name is Esteban, I'm Industrial Engineer and Excel/VBA Expert. I'm new freelance,You can see some of my experiences in my profile. I could also help in economic analysis and evaluations, based on regression stud Mai multe
Hi, I will be able to complete this Excel app (Combine Spreadsheets, Creating PIvot, Static PIvot table content, Folder Path etc., ) in quick time. My experience will be of great help for you in optimizing or comple Mai multe
I have 7yrs of experience in developing the excel macros and have did multiple macros like this in many time. I have half work ready and can give within a day I also provide solutions in excel, access, data entry et Mai multe