Changing reference cells...

Hello!

I'm attempting to save myself hours of work. Essentially I need to copy cells from one excel worksheet into a second excel worksheet with a different format. The change in format is very methodical. For example:

Worksheet 1 has data in cells:
A1
A3
A5
A7

And I would like to copy the data from those cells to Worksheet 2 into:
A1
B1
C1
D1

Without copying and pasting A1 to A1, A3 to B1, A5 to C1, A7 to D1

Obviously this doesn't work, but I in order to demonstrate my objective, I was thinking something along the lines of:

A1(Worksheet 2) ='[Worksheet 1.xls] Sheet1'!$A$1
B1(Worksheet 2) ='[Worksheet 1.xls] Sheet1'!$A$1+2
C1(Worksheet 2) ='[Worksheet 1.xls] Sheet1'!$A$1+4
D1(Worksheet 2) ='[Worksheet 1.xls] Sheet1'!$A$1+6

The bold parts being the most important ones. As of right now I'm doing this, but I'm having to type out the entire line, and change only the end. For example:

A1(Worksheet 2) ='[Worksheet 1.xls] Sheet1'!$A$1
B1(Worksheet 2) ='[Worksheet 1.xls] Sheet1'!$A$3
C1(Worksheet 2) ='[Worksheet 1.xls] Sheet1'!$A$5
D1(Worksheet 2) ='[Worksheet 1.xls] Sheet1'!$A$[B]7[/B

Doing this hundreds and hundreds of times gets extremely tedious....

Hi,

I have attached an example of how you can achieve your results using VLOOKUP.

See What you think.

Cheers

TonyB