D
deliver2ron
Here's the situation. In Sheet1 I have a list of about 1200 items in
following format:
T0000
----
AAA 00000
BBB 11111
CCC 22222
T0001
----
AAA 11111
DDD 33333
and so on.
In Sheet2, as follows:
T0000 T0500 T0700
AAA
BBB
CCC
DDD
T0003 T0100 T0900 T1000 T0350
AAA
BBB
CCC
DDD
There are about 300 of these blocks in Sheet2.
And my task is to fill out the blank cells under each id numbers in
Sheet2 with their corresponding values (if any) in Sheet1. I am
fairly new to Excel and don't have a clue as to how to go about this
problem. Any suggestions would be appreciated.
Ron
following format:
T0000
----
AAA 00000
BBB 11111
CCC 22222
T0001
----
AAA 11111
DDD 33333
and so on.
In Sheet2, as follows:
T0000 T0500 T0700
AAA
BBB
CCC
DDD
T0003 T0100 T0900 T1000 T0350
AAA
BBB
CCC
DDD
There are about 300 of these blocks in Sheet2.
And my task is to fill out the blank cells under each id numbers in
Sheet2 with their corresponding values (if any) in Sheet1. I am
fairly new to Excel and don't have a clue as to how to go about this
problem. Any suggestions would be appreciated.
Ron