R
rameter
I have a spreadsheet that is viewed and updated by many people. I'm
trying to streamline the data and I believe I need a database to do
what I need. Here is my situation.
I have a "master sheet" that contains all of the data. I need to
"query" on different sheets to summarize the data dependant on
classification that I assign on the master sheet. For example, I am
tracking projects with names, cities, sellers, descriptions, dates and
numbers. On one sheet I need to sum the number of sales for all
projects within a certain city. But that record may also appear on
another query on another sheet. The reason I want to use the master
sheet is to make sure the data is updated on all following sheets. Is
there a way to display rows of data filtered by a field?
I may not have explained this clearly...
trying to streamline the data and I believe I need a database to do
what I need. Here is my situation.
I have a "master sheet" that contains all of the data. I need to
"query" on different sheets to summarize the data dependant on
classification that I assign on the master sheet. For example, I am
tracking projects with names, cities, sellers, descriptions, dates and
numbers. On one sheet I need to sum the number of sales for all
projects within a certain city. But that record may also appear on
another query on another sheet. The reason I want to use the master
sheet is to make sure the data is updated on all following sheets. Is
there a way to display rows of data filtered by a field?
I may not have explained this clearly...