Previous Topic Next Topic

Trying to autopopulate multiple spreadsheets

Closed
Phage
Posts
2
Registration date
Thursday February 1, 2018
Status
Member
Last seen
February 1, 2018
 - Feb 1, 2018 at 10:49 AM
TrowaD
Posts
2888
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 16, 2022
 - Feb 5, 2018 at 11:48 AM
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!

2 replies

Answer 1 / 2
TrowaD
Posts
2888
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 16, 2022
 515
Feb 1, 2018 at 11:33 AM
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
0
Answer 2 / 2
Phage
Posts
2
Registration date
Thursday February 1, 2018
Status
Member
Last seen
February 1, 2018
Feb 1, 2018 at 02:03 PM
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
0
TrowaD
Posts
2888
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 16, 2022
 515
Feb 5, 2018 at 11:48 AM
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
0