Use ONE worksheet, and use these Excel features to manipulate it:
Subtotals:
http://www.officearticles.com/excel/...soft_excel.htm
Autofilter:
http://www.officearticles.com/excel/...soft_excel.htm
Pivot tables: http://www.cpearson.com/excel/pivots.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Nrippe" <Linking worksheets wrote in
message ...
I do have a P.O. format that includes data in columns (units ordered and
dollar amounts by unit & total) and rows (each one of the 3 stores). My
boss
wants me to create a worksheet that gives him the dates, total of units
per
store, vendor, purchase order #, dollar amounts per unit, and totals. I
also
would have to create another worksheet that gives him the monthly total
figures including almost the same information. Could somebody help me to
link
the P.O. to the other 2 worksheets?