• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Showing certain rows on separate sheet to master sheet depending on drop down list selection

M

mb995haq

New Member
Hi,

I have a situation I need help with.

I trying to create a property maintenance spreadsheet.

There are 10 properties which are chosen from a list. Next to this is then written the issue, cost, etc.

I would like to be able to have a separate sheet for each property as well as the master sheet. Is there a way this can be done.

I thought of simply copy and pasting the master sheet to each separate property sheet and filtering the list to show just one property....however i don't know how to auto update the other sheets when the master sheet is changed!

your advice would be most appreciated!
 
mb995haq said:
Hi,

I have a situation I need help with.

I trying to create a property maintenance spreadsheet.

There are 10 properties which are chosen from a list. Next to this is then written the issue, cost, etc.

I would like to be able to have a separate sheet for each property as well as the master sheet. Is there a way this can be done.

I thought of simply copy and pasting the master sheet to each separate property sheet and filtering the list to show just one property....however i don't know how to auto update the other sheets when the master sheet is changed!

your advice would be most appreciated!
Click to expand...

hi...
can you post a sample worksheet ??
 
You must log in or register to reply here.
Back
Top