How to create auto populating multiple sheets based on cell

Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
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!!!!

1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
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