Hide rows in range 2 based on filter selection in range 1

gtol,

It looks as if you want the filtered "Billy" "Total" be copied to the non filtered "Billy" in the 2nd table. If this is correct then you can code to have the "Estimated" days effort to the date in the second table.
Is this what you want?

Added

If the above is true then we need to be able to select the required Date.