Hi all,
I'm building a dashboard which needs to update every week. I want to build a nice, pretty table which pulls in rows of data based on certain criteria.
For example, I might want to show in the dashboard rows where the item is owned by Bill, and is red, and is Critical, but only show the owner, the unique number, and the 'irrelevant data'.
I do not want to pivot this information as I need these tables to be reproducible and copiable, I do not want to set up a pivot table each time. I also need them to look pretty - I can't customise a pivot table as much as I'd like to.
Example here: https://dl.dropbox.com/u/84751033/Example.xlsx
I'm building a dashboard which needs to update every week. I want to build a nice, pretty table which pulls in rows of data based on certain criteria.
For example, I might want to show in the dashboard rows where the item is owned by Bill, and is red, and is Critical, but only show the owner, the unique number, and the 'irrelevant data'.
I do not want to pivot this information as I need these tables to be reproducible and copiable, I do not want to set up a pivot table each time. I also need them to look pretty - I can't customise a pivot table as much as I'd like to.
Example here: https://dl.dropbox.com/u/84751033/Example.xlsx