Hi Lost,
Could you expand on the pivot table, I have never gotten them to work.
Su
- select table (if this one expands over time, select entire columns)
- Data, pivot table, finish
- drag the first three columns to the row area
- rightclick each column in that row area, select "Field Settings..."
- Select "None" for subtotals
- drag the REC DT to the data area and you're done.
Now after entering new data, just refresh your pivot table and you're
done.
Regards,
Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com