Please refer to attached file.
Based on the users selection on "test" worksheet cell d4, I an trying to place the contents of the relevant named table from "Pilots" worksheet into the block of cells between B7 and L14 on "test" worksheet.
I'm not sure whether this can be done as formulas within excel or whether it needs to be done as vba.
Any help would be greatly appreciated.