Some general thoughts, maybe just combine it via quick manual steps ..
You have 2 identically structured data sheets
Make a copy of the sheet with 2007 data, then in this copy, copy the 2008
data, paste it below the 2007 data
If there's no dates col in the original data to differentiate, then just use
an adjacent col, enter a col header, eg: Year, type 2007 in the 1st data row,
copy down to the last row of 2007 data. Type 2008 in the 1st row of 2008
data, copy down to the last row. Done. You can now pivot on the combined
data.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400 Files:358 Subscribers:55
xdemechanik
---
"Peledon" wrote:
I want to combine two worksheets into one summary worksheet so I can create a
pivot table to chart dates along x-axis and numbers y-axis, legends being
Open and Closed. My worksheet 1 consists of 2007 data and my second
worksheet consists of 2008 data. They have same labels.