Hi,

I am using Excel 2002 and I am trying to find a simpler or elegant way in
doing cell reference. Here is my example I will have a column let's say
from A1 to A10 in worksheet name "Insured". What I want to do is to get the
information from A1 to A10 and put in a different worksheet called "Policy
Holder", but the trick is I want the information starting from A1-J1 (row).
Any tips will be appreciated. Thank you in advance.