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.
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!!!!
How to create auto populating multiple sheets based on cell
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.