Can I use a pivot table with this efficiently?

D

Darren Ingram

Hi,

I have two worksheets. On the first worksheet I have the information that
the Nursing Home supplies me with. On the second worksheet I use the
information that the 1st worksheet has and mix it with what-if type formulas
and produce answers. I can then print out the answers in the second
worksheet.

My problem is: I have 80 nursing homes. I don't want to have 80 x 2
worksheets with imput and answer sheets. (160 sheets) Can I create a pivot
table type scenerio and just put in the data for the 80 homes into one sheet
and have it automatically print the 2nd "answer" sheet for all the homes?

All thoughts greatfully received!
 

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

Dealing with a Pivot Table (when I don't want to) 0
Pivot table 0
Pivot table data source 1
to copy pivot table as new sheet with same format 3
How to filter rows data based on background color of individual cells 3
Pivot table format on paste values 0
Pivot Table using dynamic worksheets 2
Can I refresh worksheets in a specific order when I open a file? 0

Top