I have a Microsoft Excel 2010 spreadsheet that currently has 11 sheets. 10 of the sheets will contain a simple 1 column list of towns, cities or villages and I want the 11th sheet to be a master list of towns, cities, villages that I select.
Obviously I could go through each sheet cutting and pasting but this is going to take a long time so instead I would a faster method of creating a master list (alphabetical order).
I only have basic Excel abililites but found user the developer tab that I can place a tick box in the column next to these destinations. Therefore my idea is that the master list sheet could be updated automatically when tick/untick any destination.
I have attached a Microsoft Excel file although currently only 2 of the 10 sheets are [url removed, login to view] destinations. My idea is that if a freelancer can provide a solution then I can follow what he/she has done on these 2 sheets and apply it to the other 8 when they become populated.