Fermé

Combine Data From Multiple Sheets in Excel (VBA)

Hi

I need VBA code to combine data from multiple sheets into one, based on "parent ID". For example if on Sheet 2 is data that related to Sheet 1, and on Sheet 3 is data that is related to Sheet 2, I need those data combined on Sheet 4 in "Tree View Mode", like:

Sheet 1 Data

- Sheet 2 Data

- - Sheet 3 Data

- - Sheet 3 Data

- - Sheet 3 Data

- Sheet 2 Data

- - Sheet 3 Data

- - Sheet 3 Data

- - Sheet 3 Data

Sheet 1 Data

Sample of how data should be combined is on Sheet named "combined" (all Sheets should be combined there). Also first row on Sheet "combined" shows the correct order of data columns that should be copied from other Sheets.

COPYING ALL DATA FROM ONE SHEET AFTER ANOTHER IS NOT A PROPER WAY TO FINISH TASK!

PROPER WAY IS DESCRIBED ABOVE AND PRESENTS ON THE SAMPLE OF SHEET "COMBINED".

If you have any question - please let me know

P.S. Before posting your proposal - please make sure that you'll be able to finish project and, please, make atleast small part of code that properly combine data.

Thanks

Link to file - [login to view URL]

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

En voir plus : extract data from website to excel vba, pull data from website to excel vba, extract data from pdf to excel using vba, vba code to extract data from website to excel, automatically pull data from website into excel vba, extract data from word to excel vba, pull data from pdf to excel vba, import data from access to excel vba, how to get data from web in excel vba, transfer data from word to excel vba, get data from access to excel vba, google spreadsheet combine data from multiple sheets, extract data from powerpoint to excel vba, retrieve data from access to excel vba, combine data from multiple excel files, how to combine data from multiple excel spreadsheets, how do i combine data from multiple rows into one in excel?, combine data from multiple workbooks into one excel, copy data from website to excel vba

Concernant l'employeur :
( 2 commentaires ) Lviv, Ukraine

Nº du projet : #31444938

14 freelances font une offre moyenne de 36 $ pour ce travail

(468 Commentaires)
8.4
(85 Commentaires)
5.7
(131 Commentaires)
6.1
(34 Commentaires)
4.2
yesubabu10203

Hey hi , myself Yesu , I am a VBA developer, I can do this , you can contact me on this for further discussion thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(22 Commentaires)
4.1
sprakashtfoss

Hi I can assist you by completing the task with great accuracy. Already dine this sort of projects earlier. Thanks SP

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)
2.0
jimohmusa80

Professional data entry specialist with skills and accuracy, deep knowledge of Microsoft word, excel, data processing, Web search and copy typing.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
mohammadabubakr3

Hello, I am a professional data entry operator I am interested in working with you I have read your need I have done this job at the right time I have seen the project and I think I am ready for this job Be suitable Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
greetnicole

Dear Prospective client from Ukraine, I have read your project details and will be delighted to combine multiple sheets into one, based on "parent ID". I am proficient in working with all the Microsoft office and I am Plus

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

I have excellent Microsoft excel skills and over 5 years of work experience. Some of my areas of interest include: Data entry and analysis.

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

Hi sir, I have read your project details and I have completely understandg you need. I'm experienced in Ms Excel, Data Entry, online Data Entry, Google sheets, visualisation of data. I do my work with 100% accuracy wit Plus

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

i am a good data entry freelancer (any type). if you give the project i will complete in time as soon as possible.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
Sesathya22

I am excel vba macro expert i already done this same activity multiple times i can help you on this.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0
KORLAKANTI

HII IAM VIKRAM AND IAM REALLY HAPPY TO EAR THIS OPPOTUNITY FROM YOUR SIDE IAM AN EXPERT IN THIS IF YOU HAVE ANY DOUBT YOU CAN TEST ME WITH A DEMO WORK AND I WILL PROVE MY TALENT AND I WILL DO WORK SUCCESSFULLY AND I W Plus

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