If your data is laid out nicely, maybe you can use use .offset to find the name
of the fund and plop it next to the cell (or even within the cell) that is after
the page break.

I didn't understand the layout of your example, but something like this:

If nextTrx.Value Like "FUND*" Then
nexttrx.value = nexttrx.value & "--" & nexttrx.offset(3,2).value
...

Change (3,2) to go down/over as required.



"keith2816 <" wrote:

hi dave,

What I meant was that I have the following data in excel format, for
example (the data is extracted by software and thus by default the
'count' and 'fund' is on the same column as Trx.No.

*Daily Report*
Fund TrxNO. Units etc...........
Superfund 12345 300 etc.........
count:1 300
Superfund fund: 1 300

hellofund2 123456 100
hellofund2 123457 200
count:2 300
hellofund2 fund: 2 300

The said data is sorted by fund name and my previous macro will
actually peform some function after which it will 'page break' after
the occurrence of the word "Fund" in the Trx No. column.
The purpose of the break is so that i can have different fund on a
fresh sheet of paper.

What I wanted to do is to have those reports to be able to print the
fund name after the heading , in this case "Daily Report".
As there's a page break at "fund" level, I will need something that
will be able to insert at the right place...
thks...

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

--

Dave Peterson