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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - 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 responses

Answer 1 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 549
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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 549
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

Similar discussions

Excel - IF function with multiple words
Nick -
user -

14 responses
Generate excel workbooks based on excel list
m_albges -
rivera -

23 responses
Excel multiple functions in one cell
todd -
rizvisa1 -

1 response