I have created a spreadsheet that has worksheets which need to filled in for
every day of the month. There is a spreadsheet for each month of the year.
On each worksheet for each day there is a validation drop down list which
takes its information from a list on the bottom of each page. There are two
columns beside the drop down list that use drop down for a vlookup. The
problem i have is that the information will change from time to time and the
list for the drop down and vlookup will be updated. When the lists need to
be updated I have to go to each individual sheet from when it needs to be
updated, unlock the sheet, insert the new items into the list or update the
current lists information, resort the list and then reprotect the worksheet.
Is there any easier way of doing this?