Automatically copy rows to a separate worksheet

[obamamama]

Hi Everyone!

I have various contact information going across a row (Q4:Y4) in Sheet1. I want to get this information to automatically replicate in Sheet2 (A2:I2).

I do not want A4:P4 in Sheet1 to be copied into Sheet2, only the information in Q4,5,6,7,etc through Y4,5,6,7,etc.

Is there a formula that would allow this information to automatically populate into sheet 2?

I've attached the worksheet and would appreciate any help!!

Samantha

[Simon Lloyd]

you could always do it with formula!:
in sheet2 A2 type =Sheet1!Q4 and then copy across, the data will always be current!