I've inherited the task of keeping a group of reports
updated monthly. In the old workbook, the layout on one
report in particular included various footnotes. There were
blank columns inserted after each column of numbers and
there were footnote numbers next to cells that had a
footnote. For example:
Str # Salaries Adv Ins
500 15.00 (1) 32.50 (2) 47.52 (3)
and so on
then after the grand total line were the footnotes:
Salaries
1 footnote text here
Advertising
2 footnote text here
Insurance
3 footnote text here
I've converted all the reports in the workbook to pivot
tables because they must be updated with new rows every
month. But I can't think of any way to retain this footnote
system. Especially a way that will allow the pivot tables to
be constantly refreshed. Any ideas on this?
Thanks!
Crystal Khan
Oklahoma City
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
|