Hello guys i have attached images of the file that i have: Main sheet: https://imgsafe.org/image/0a2759f0ff Data Sheet: https://imgsafe.org/image/0a275c795a I am collecting information from 12 departments and i need to collate them all into one sheet. Each department has it's own tab where they enter the data (Data Sheet Image) in the tab, they have different zones where to enter the data depending on the meeting session that we will have. in the Main sheet, you can see that there is an area where i enter the session meeting. What i would like to achieve: Once i enter the session number in the Main sheet, the information in the different tabs is placed into the main sheet under each header for department Please let me know if you require further explanation on what i am trying to acheave Regards

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Adding rown from sheet to sheet

Thread starter didier
Start date Sep 19, 2017
Tags

data enter main session sheet

didier

New Member

Sep 19, 2017

Hello guys

i have attached images of the file that i have:

Main sheet: https://imgsafe.org/image/0a2759f0ff
Data Sheet: https://imgsafe.org/image/0a275c795a

I am collecting information from 12 departments and i need to collate them all into one sheet.

Each department has it's own tab where they enter the data (Data Sheet Image)
in the tab, they have different zones where to enter the data depending on the meeting session that we will have.

in the Main sheet, you can see that there is an area where i enter the session meeting.

What i would like to achieve:

Once i enter the session number in the Main sheet, the information in the different tabs is placed into the main sheet under each header for department

Please let me know if you require further explanation on what i am trying to acheave

Regards