Trying to autopopulate multiple spreadsheets

Closed
Phage Posts 2 Registration date Thursday 1 February 2018 Status Member Last seen 1 February 2018 - 1 Feb 2018 à 10:49
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 5 Feb 2018 à 11:48
I have a workbook with contact and personal information of an organisation. I would like to have this information auto populate to separate sheets in the same workbook by sections. The other sheets will be name 1Section, 2Section, 3Section.

Many thanks for any assistance!
Related:

2 responses

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
1 Feb 2018 à 11:33
Hi Phage,

Have a look at this thread:
https://ccm.net/forum/affich-689438-autopopulating-multiple-sheets-from-one-main-sheet#p1010274

When your sections are located in column G then you can use the code from post number 43.

Let us know if and where you get stuck.

Best regards,
Trowa
Phage Posts 2 Registration date Thursday 1 February 2018 Status Member Last seen 1 February 2018
1 Feb 2018 à 14:03
Hi thanks, I think i forgot to state, I would like each section's sheet to be populated by a part of the main sheet.

Also, i don't quite understand that other code that you referred me to.

Thanks
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
5 Feb 2018 à 11:48
Hi Phage,

Could you answer the following questions for me:
1. Which columns of the main sheet would you like to copy over?
2. Which column on the main sheet holds the sheet names (sections)?

Best regards,
Trowa