Copy a row from master sheet and paste it to a specific worksheet based on tab name

Hi,

I am trying to figure out how to make it so when I select my store name in row E on the Master Tab (I will be adding a lot more stores and store names in the future) it will copy that row (I really only need columns A through D) and paste it to the next available row on the stores own tab. Also is there a way to do this outside of using a button? Ideally I'd like to make it so when I select the store name from the drop list it does right away. I would just like to minimize any duplicates or hitting that store twice. Any point in the right direction would be greatly appreciated.

Thanks,
Pete

Maybe:

Please Login or Register  to view this content.