Your post is almost devoid of meaning. Neither I nor anyone else is likely to get any idea of what you want to do.

We are not mind readers. You've told us nothing about the structure of your workbook (except that is has at least 2 worksheets) or the layout of your worksheets.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]