Hi Dave,

My "Daily Report" is at the first row of the sheet and I uses pag
sheet to repeat row 1 so the "daily report" will be print on ever
page. I also cannot insert "Daily report " on every new fund as I d
not know how much of the DATA will be extracted. The data from my shee
is extracted from external software.

Thus in this respect, I cant use the subtotal function at all a
there's also count function on my excel sheet extracted from externa
software.

I need some something that will perform the following:
Daily report
Fund name 1
Data..................
(page 1 using page break from current macro)
Daily Report
Fund Name 2
Data................
(Page 2 using page break from current macro)

pls assis

--
Message posted from http://www.ExcelForum.com