Pulling data from one sheet to another

[barrywilson]

I'm having problems with retrieving certain data from one sheet to another and I don't know if it is possible.

See the below data as an example of what I'm using:

VERSID DOC LH EN VELS COUNT

1233 Duplex 100 500 503 G
1233 Duplex 101 501 520 I
1675 Simplex 100,105 500 520 G
1675 Simplex 101,106 501 503 I
1674 Simplex 100,105 500 520 G
1674 Simplex 101,106 501 503 I

Versid numbers are unique to each set of data, however the sheet I want to tie this up with use a different set of references. The reference is uses for example would be 4500 which is really 1233 (as seen above), so on sheet 2 I would want to have in say cell A1 4500 in it but then populate with the DOC,LH,EN and VELS numbers that are relevant to it and found on sheet 1 and place these on B1,C1,D1 and so on. I could enter this manually of course but in total there is 953 rows.

To complicate matters worse, you will see that there is 2 rows for each versid number, they are separated by the 'count' heading as it will either be a G or an I.

Do you think it will be possible to transfer the data from sheet 1 to sheet 2 easily?

EggHeadCafe - Software Developer Portal of Choice
.NET - Writing a self-updating application in C#
http://www.eggheadcafe.com/tutorials/aspnet/b77d98c4-3137-4bb7-9df7-85ec9bf2e619/net--writing-a-selfupd.aspx

[Pete_UK]

Do you have a table that links the alternate reference codes to the
Versid codes?

Pete

> .NET - Writing a self-updating application in C#http://www.eggheadcafe.com/tutorials/aspnet/b77d98c4-3137-4bb7-9df7-8...