Autofill from Vertical to Horizontal

[mrsmunk]

I have a sheet that is used for data input that is entered vertically for payroll information. I want to be able to link that information to another sheet and then autofill horizontally

For example

Payroll entry sheet
A b
John Smith Jane Doe
$2,000.00 $3,400.00
$2,100.00 $3,400.00
$2,000.00 $3,400.00
$2,100.00 $3,400.00
$2,000.00 $3,400.00
$2,100.00 $3,400.00

12 Month Pay info
Col A Col B Col C Col D
John Smith $2,000.00 $2,100.00 $2,000.00
Jane Doe $3,400.00 $3,400.00 $3,400.00

I want to be able to fill A1 and then autofill the rest w/o using a VB script. Is this possible?

 

[mrsmunk]

It worked for one row but not the entire array.

 

[j_latendre]

Yes, for your exmaple you would have to do each row, therefore the macro previously posted would be a better choice if it works.

 

[mrsmunk]

This worked for one row but not the entire array.

 

[mrsmunk]

sorry - I didn't see my reply so I re-posted.
I like the Transpose function though. It will come in handy in the future.
Thanks again.
Terri