Excel Macro to work on all excel files in a given folder

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.

Kompetens: Databehandling, Excel, Visual Basic, Visual Basics för apps

Visa mer: excel vba open all files in folder, vba loop through files in folder and open, run macro on all files in folder, vba code to open excel file from folder and copy data, excel vba open files in folder one at a time, vba loop through files in folder and subfolders, vba find file in folder and subfolders, excel vba copy data from all files in a folder, excel macro filling excel sheet, excel macro copy excel data, excel macro export text files, macros written excel 2000 work excel 2007, excel macro import project files, excel macro switch excel application, excel macro paste excel clipboard, excel macro work external application, excel macro check excel files directory, excel macro find records files, bid excel macro work, excel macro work required job work

Om arbetsgivaren:
( 102 omdömen ) Katy, United States

Projekt-id: #17994833



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 Mer

$55 USD inom 1 dag
(3 omdömen)

18 frilansare har i genomsnitt lagt bud på $133 för detta jobb


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 Mer

$180 USD inom 3 dagar
(290 omdömen)

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 Mer

$166 USD inom 3 dagar
(174 omdömen)

Dear client I have previously carried out a number of projects in excel using macros. Kindly contact me for further details. Roy

$250 USD inom 3 dagar
(273 omdömen)

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.

$155 USD inom 3 dagar
(63 omdömen)

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 Mer

$166 USD inom 3 dagar
(24 omdömen)

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: Mer

$100 USD inom 2 dagar
(18 omdömen)

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 Mer

$100 USD inom 2 dagar
(14 omdömen)

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 Mer

$200 USD inom 3 dagar
(5 omdömen)

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.. Mer

$50 USD inom 1 dag
(8 omdömen)

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 Mer

$30 USD inom 1 dag
(6 omdömen)

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 Mer

$140 USD inom 2 dagar
(6 omdömen)
$30 USD inom 3 dagar
(1 omdöme)

I will complete with acccuracy. and before time line..

$188 USD inom 3 dagar
(0 omdömen)
$111 USD inom 10 dagar
(0 omdömen)
$155 USD inom 3 dagar
(0 omdömen)
$277 USD inom 20 dagar
(0 omdömen)

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 Mer

$35 USD inom 1 dag
(0 omdömen)