In sheet A, cell E23 there is a drop down list containing 4 words, Monarch, Rollaway, Foldaway, Glide. In sheet B there are formulas for the Monarch, in sheet C formulas for the Rollaway and so on.
In sheet A, there is other data in various cells. When I select the word Monarch from the list in sheet A, I hope to have the data in sheet A transfer to the corresponding cells in sheet B, only, for the Monarch. And similarly when the word Rollaway is selected in the list in sheet A, the data will transfer to only sheet C for the Rollaway.
Hoping for help, been struggling with this for days.
Thanks.
In sheet A, there is other data in various cells. When I select the word Monarch from the list in sheet A, I hope to have the data in sheet A transfer to the corresponding cells in sheet B, only, for the Monarch. And similarly when the word Rollaway is selected in the list in sheet A, the data will transfer to only sheet C for the Rollaway.
Hoping for help, been struggling with this for days.
Thanks.