EPTI need help with the data tab and specifically data validation. From my understanding of it so far, I can use data validation to create a list/combo box from a range of cells in my spreadsheet.
I'd like to have a setup like this:
Sheet 1 - List box of employee names and a second one with the list of projects.
Sheet 2 - A complete schedule of what days people work with what project they are working on that ONLY shows what I have selected on the first sheet. (IE: Hide cells that are not selected)
So I need to know how to program these list boxes to change my spreadsheet based on what is selected. From the little bit I can tell so far, HLOOKUP and VLOOKUP can pull my selections from the list box on the second sheet and I could generate it through these functions, but I don't really know how they work that well. Any tips? Thanks!
