I'm using Excel 2007. I would like to seek some advise on how I may update cells after selecting a status from a drop down list.
Basically I have created a simplified version of what I intend to have. On the 1st tab “Master”, I will fill up a table with information. I want the information to pre-populate to the remaining tabs depending on the item selected in Column I (Status field). (Column I is a drop down list hidden at the bottom of the spreadsheet). Upon selection of the Status from the drop down list, I would like the cells to display (fetch) the data from the “Master” worksheet.
Bookmarks