Basically work have an excel file detailing purchases that have been made. They have columns for various details. At the head of the column they have a box. In the box you can select say "Joe Bloggs" and it will list all of the orders requested by Joe Bloggs.
The problem is these functions no longer work. I have checked on a previous page of the spreadsheet where they work and I cannot find anything different.
For a start, on this particular sheet it doesn't list all of the names in that column (there are blank rows between columns as the orders have to be input in the correct order number). It also won't do anything.
On the sheet that works - the box lists all of the names of the people who have requested orders. When you select the name - it just shows orders shown by that particular person.
Any help would be appreciated.
The problem is these functions no longer work. I have checked on a previous page of the spreadsheet where they work and I cannot find anything different.
For a start, on this particular sheet it doesn't list all of the names in that column (there are blank rows between columns as the orders have to be input in the correct order number). It also won't do anything.
On the sheet that works - the box lists all of the names of the people who have requested orders. When you select the name - it just shows orders shown by that particular person.
Any help would be appreciated.