Terminé

VBA to pull and flatten data from multiple sheets

Working on processing data at a university, and am in need of the development of a standalone VBA in excel file which will:

1: ask which file to process

2: Extract and flatten (unpivot) each Green/Blue/Red heading table combination in the worksheets NOT labelled INPUTS or TOC (variable worksheet counts, table counts, table rows & columns) as seen in Example

3: Output the flattened data, query parameters and Green/Blue/Red titles (column Q in ExampleOUTPUT) to a file structured similar to ExampleOUTPUT (attached)

Compétences : Excel, Visual Basic, Traitement de Données, Visual Basic pour les apps

en voir plus : sum data multiple sheets, vba excel print multiple sheets, macro place data multiple sheets entry excel, how to extract data from one sheet to another in excel using vba, excel vba copy paste range another worksheet, how to copy data from one excel workbook to another using macro, excel vba copy range to another sheet, excel vba copy data from one sheet to another based on cell value, excel vba copy data from one open workbook to another, convert hierarchical data to flat excel, macro to copy data from one sheet to another based on criteria, php importing data excel multiple sheets, summing multiple sheets data using macro, select print multiple sheets using vba, excel vba code pull internet data, excel grab data multiple sheets, excel vba exporting data multiple sheets, vba sum cell multiple sheets, macro vbscript import data multiple sheets excel, split data multiple sheets excel

Concernant l'employeur :
( 0 commentaires ) Old Town, United States

Nº du projet : #26877381

Décerné à:

writingapp

Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within 1 day

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(54 Commentaires)
5.4

9 freelance font une offre moyenne de $125 pour ce travail

(798 Commentaires)
8.6
zu02

Hello I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VBA. I'm professional Ms Access/Excel/vba coder. I'm coding in vba since Ms Office 97 released. Please visit (where I'm wo Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(33 Commentaires)
5.8
nemanjadj20

Hello? I have worked on Excel/Word/PPT/MACRO projects to what you are looking for, and I am confident I can exceed your expectations. I have attached samples of work very similar to what you are seeking. # create Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(6 Commentaires)
4.4
hayteekeys

Hi, I'm a professional and expert in Data works or projects..My skills and services include: - Web scraping - Data entry - Data mining - Data processing - Excel - MySQL - Oracle -Financial Analysis -Advanced Excel -MS Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(9 Commentaires)
3.7
arunkumar9896

Hi, I'm Arun. I would love to hear more details on your project so I can get you an accurate quote and timeline. I'm a VBA Certified Developer Associate and I've helped create excel macros and database in the past. I Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(1 Évaluation)
2.0
SolutionWhiz

Hi, VBA to pull and flatten data from multiple sheets I am so much interested in taking this project up for you. I have over 6 years’ experience in Office suite and also have a good command over MS Excel which includ Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
1.7
expertsmarti11

Hi, "I have gone through your description. "This is my area of specialization, i can get it done perfectly well. Please ping me in person. I can help you to complete all tasks. I and my team have hands-on experience i Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
HritickRanjan

I have a very unique name for the brand website games app name and have an experience of 5 yrs . Before hiring me you have to pay me [login to view URL] you. Relevant Skills and Experience I have a very unique name for th Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0