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.

Beceriler: Veri İşleme, Excel, Visual Basic, Uygulamalar için Visual Basic

Daha fazlasını gör: 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

İşveren Hakkında:
( 102 değerlendirme ) Katy, United States

Proje NO: #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 Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(3 Değerlendirme)

Bu iş için 18 freelancer ortalamada $133 teklif veriyor


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 Daha Fazla

in %bids___i_period_sub_35% gün içinde180%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(290 Değerlendirme)

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde166%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(174 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(273 Değerlendirme)

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.

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(63 Değerlendirme)

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde166%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(24 Değerlendirme)

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: Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(18 Değerlendirme)

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(14 Değerlendirme)

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)

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.. Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(8 Değerlendirme)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(6 Değerlendirme)

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde140%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)
in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

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

in %bids___i_period_sub_35% gün içinde188%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
in %bids___i_period_sub_35% gün içinde277%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)