I have recently built a sharepoint database made up of multiple lists. I have exported the contents of two of the lists into excel as seperate worksheets of the same document (which will now automatically refresh the data from the lists every time I open the document).
What I want to do now is create some more tabs in the document to show reports pulling in data from the two sheets.
What I would initially like is a sheet with some drop down filters at the top, and then displaying rows below.
Take the most simple example - imagine one of my sheets is a table with just two columns, name and child's name. A person can appear multiple times in the "name" column, with then each of their children's name in the second column.
I'd like to create a sheet with a drop down at the top for "name", and when you then select a name it populates underneath with a list of each of their children, one on each row - so I'd like to find the first instance, the second instance and so on.
Hope that makes sense and someone can help me out.
Thanks
What I want to do now is create some more tabs in the document to show reports pulling in data from the two sheets.
What I would initially like is a sheet with some drop down filters at the top, and then displaying rows below.
Take the most simple example - imagine one of my sheets is a table with just two columns, name and child's name. A person can appear multiple times in the "name" column, with then each of their children's name in the second column.
I'd like to create a sheet with a drop down at the top for "name", and when you then select a name it populates underneath with a list of each of their children, one on each row - so I'd like to find the first instance, the second instance and so on.
Hope that makes sense and someone can help me out.
Thanks