Hi all,

I have a table named "Bookies" and it has 2 columns/headers (Key and Bookmaker). The list is about 75 cells long.

I need another table on a different tab and I would like to copy ALL of the bookmakers from the Bookie table and the column named Bookmaker.

Is this possible? Someone else showed me this command =IFERROR(VLOOKUP(ROW()-1,TB_BookieName,2,FALSE),"") but that does not create the list of bookmakers in the other table. i have to tab 75 times to get to the bottom but if i add more bookmakers it will not auto update. I only want to keep one list up to date and the other one just need to auto update.

Thank you in advance