Gathering data to a master spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I currently have a spreadsheet that contains 5 questions that I would like to
send out every quarter to different departments to evaluate different
companies. I've tried to make this survey as automated as possible by
incorporating drop downs for what quarter the evaluation is for, what
department is doing the evaluation, company(ies) evaluating, and amount of
points to be rewarded.

Is there a way to have these answers transfer into a master spreadsheet,
organizing the data by what department evaluated, company and points given
for each question. This way I can calculate the average points scored for
each company.

Thank you.
 
A pivot table with multiple consolidated ranges would let you refresh
at any point and give you lots of flexibility for viewing by dept,
scoring etc.

Jesse
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sending each spreadsheet via email to a different person 2
Lookups - how to obtain data from a master spreadsheet into another 5
Excel Profit & Loss 2
Excel Populate Delivery Note 0
Creating separate spreadsheets from a master spreadsheet 2
Gathering data 1
Name A Range 5
Trying to evaluate cell referenes in a string 3

Back
Top