"Mindie" wrote in message
...
Yes, the pages are loaded from the top. From there on you lost me. I am
not
much of a VBA programmer, I am more 400/mainframe. Any ideas?
It just struck me that you should be able to use the OFFSET function
http://www.techonthenet.com/excel/formulas/offset.htm
You could do something like this in Sheet3
=OFFSET(Sheet1!$B$3, A1,0,1,1)
The idea is that when new rows are inserted, you enter the number of rows
inserted as the offset in cell A1 in Sheet3. You could also add some code to
tour macro that would insert this number in A1
/Fredrik