multi-sheet

I am trying to do the following, here's some images explaining it: 2: 3: The WO# never changes and never repeats. There can be 1,000s of w.o. numbers and I avoid defining definitive ranges in VBA because data is constantly added and deleted. To help solve this problem, I used this formula...

I use macros extensively in my work and recently wondered if I could speed things up by merging files into one workbook and applying the macro using the option to apply to all sheets . Fixed formats for column and row dimensions work ok but color coding with conditional formats do not. I am...

OK, here is what I am trying to accomplish: I have one cell (M12) that uses a data validation list that is tied to all the names of the worksheets in the workbook. I want the user to be able to select the worksheet they want to use in the first validation list, then have a second validation list...