Finalizat

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.

Aptitudini: Procesare date, Excel, Visual Basic, Visual Basic pentru aplicaţii

Vezi mai multe: 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

Despre angajator:
( 102 recenzii ) Katy, United States

ID Proiect: #17994833

Acordat lui:

boscojfelix

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

%selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD în 1 zi
(3 Recenzii)
1.8

18 freelanceri licitează în medie 133$ pentru acest proiect

schoudhary1553

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(290 recenzii)
7.6
avinav606lx

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(174 recenzii)
6.5
TonmoyRoy111

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(273 recenzii)
6.5
periyannas

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.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(63 recenzii)
5.6
nelumindralal

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(24 recenzii)
4.3
gsanggara

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(18 recenzii)
3.6
paulodayto08

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(14 recenzii)
3.3
lightingdavid

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(5 recenzii)
2.9
Mokshith30

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

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(8 recenzii)
2.7
egafiori

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

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(6 recenzii)
2.2
kumarapush777

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(6 recenzii)
2.3
%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(1 părere)
0.7
ramchoudhary344

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)
0.0
%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 10 zile
(0 recenzii)
0.0
%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)
0.0
%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 20 zile
(0 recenzii)
0.0
vpalankar6

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

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)
0.0