Hi all,
Sorry if I don't use the correct terms, I have used Excel all my life but am not a pro by any means.
I have 3 pages, each with a table on it referring to football players. Page 1 is the main table, which gets data from the 2 other pages relating to different competitions. All 3 pages have identical columns. If I enter data on 2 or 3 I have it formulated so it feeds into page 1 using this formula: ='Players - SP'!G2+'Players - Online'!G2
What I want to be able to do, is sort*the tables on*2 and 3 by different stats, (such as goals) but keep the stats in the correct row on page 1. Let me know what you think.
I understand this may not be too clear. Please message if you have any question.
Bookmarks