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 December 27, 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 responses

Answer 1 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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 December 27, 2022 552
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
Can’t Log into Instagram from Multiple Devices
Isabella -
Abhishek0025 -

5 responses
Cannot download multiple files at once in WhatsApp Web
nemonavicusrino -
dannygzus -

4 responses