How to create auto populating multiple sheets based on cell

Closed
helena - Aug 27, 2015 at 10:17 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 1, 2015 at 11:53 AM
Hello,

I'm currently creating a building condition assessment form. I would like to know how to create auto populating multiple sheets once I select the data from the drop down list.

For example:
Building - 123 Simcoe St. has 5 meeting rooms on 1st floor
On the excel spreadsheet, I have the drop down list to select the building and floors. Once I selected 1st floor, I wanted to have 5 sheets (same format) auto populate out at the bottom to fill out.

Is this doable?

Thank you for all your help!!!!
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Sep 1, 2015 at 11:53 AM
Hi Helena,

I'm sure it is doable, if only I knew what you mean ...

Consider the option to post screen shots (using the mountain icon above the message body) or your workbook (using a free filesharing site like www.speedyshare.com or ge.tt among others and then post back the download link. Careful with sensitive information).

Try to make it clear how it is now and how you foresee the end result.

Best regards,
Trowa
0