Have you thought about keeping the data in one location and using
data|filter|autofilter to show what you want (and hide what you don't want).
Then print from there.

Lovis wrote:

i need to split a long table into shorter ones so that i can print on one
sheet and the table to remain linked.
am using 2003 excel and only way have found so far is to copy and paste
picture link but this is long winded and a pain to line up profesionaly.
any help thanks.

--

Dave Peterson