I have a foortball pool with 10 participants.
My Excel file contains 11 sheets; 10 participants and one for the league game schedule.
Each participant picks 6 teams within the league.
On each participants spreadsheet I want to import the schedule of the teams they picked from sheet 11.
Sheet 11 (named schedule) has 15 coloms X 25 lines .
The line contains the name of the team followed by the schedule of the year.
The first row has the name of the team followed by all the games scheduled for the year (14 rows) fore a total of 15 rows.
On each of the particpants sheet, I used the VLOOKUP command to find their picked team in sheet 11 then I want to be able to copy the line of their games (14 rows) which is on the right of the team's name and import it in the particpant's sheet.
Thanks
Richard