I have 4 sheets named A B C D and in each sheet the important cell is B6. On a separate sheet I have a data validation cell with a dropdown box with A B C D. On choosing a particular sheet name I want the cell below to become the corresponding value in B6 of the appropriate shheet.
Any help would be appreciated
Any help would be appreciated