I have a lot of data that I need combined in pivots to compare. It's difficult to explain without showing you the files. I had help from someone here (I wish I could find them) who designed a table with prices, so when I enter the data, the price automatically shows in the column. I need to combine a years worth of data (I enter data for each month or a two month period) so I can analyze different prices. For example: Last year I had set prices for 17 different items. At the end of last year, I did "X" amount of items 1,2,3... Let's say item #5 was $40.00 and item 13 was $100. I first need to combine all the data in pivots and then I need a table where I can play around the figures to see what I could have made with the different prices. I'm sorry if I'm not explaining properly.

I also need help in formatting data for print. Someone set up a template from which I do all my work on. I need help in setting up where the pages automatically print with pivots of the data and a cover sheet that shows all the data from the main sheet. As it is now, it's just one long data sheet. I can send you my data and then a sample of how the last one was formatted. You will understand completely.

I'd rather not post the data online here, but I can email you everything.

Thank you!

Marty