B
barry wilson
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/tutorial...9df7-85ec9bf2e619/net--writing-a-selfupd.aspx
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/tutorial...9df7-85ec9bf2e619/net--writing-a-selfupd.aspx