Originally Posted by
JBeaucaire
Um, you missed my point, my formulas DO that. I've incorporated cell A1 into the formulas as the central matching piece of data, so it DOES reassess the data for the name of the person listed in cell A1, and since you display that name by the sheetname....it IS dynamically doing as you wish.
If I'm missing some other component, let me know and I'll adjust it.
Even though the formula references A1, the name of the sheet (bob in the below example) is static and has to be updated for each sheet:
In the above example, bob's name is static. I wasn't able to use my little formula snippet to automagically draw the current tab's name into the sheet refererence within your formula (as I do in cell A1 of each worksheet).
One other thing that I forgot to include in the sample data is that there are weeks when two of the engineers will not work (always the same week) e.g. Bob and Bill may not work in week 8. The formula needs to account for that and show "Not Working" or something to that effect.
To do the above, I added in:
It's a temp fix at best because it has to be different than the rest of the formula.
Thanks again,
CT
Bookmarks