I am building a set of spreadsheets to record results and points for a
fantasy sport game. I have designed it so that the user inputs all data on
one sheet. They input the result for a player and at the top of the sheet the
round involved. Then it populated specific tables for that round with all the
data including the points awarded. All works fine but when I move onto
another round the previous rounds data is lost on all tables. Is there a way
of fixing the data from previous round?