Hi,
I'm trying to get a dropdown box which auto populates cells next to it from data on another sheet, depending on the value in the dropdown box. Say I had data A1-D10, and I make a dropdown box of values A1-A10. Should I select the A1 value in the box, the cells next to it would populate with B1, C1 and D1. Thanks in advance!
Bookmarks