Hello,

I need help trying to get data from sheet 1 into sheet 2, in the right
spot. Here's what my data looks like:
(sheet 1)

D 240102 x 90 200
D 240103 y 9787 100
D 240107 z 8897 200
D 240110 a 45 640

(blank row)
S 240229 j 4545 100
S 240232 k 544545 200
S 240233 l 454556 124
S 240238 m 45456 135

(blank row)


And here's the template where it needs to go (only the numbers in
columns 4 and 5 need to be filled in underneath each other for the
matching 240xxx number, the template with the numbers in column B is
already filled in)

(sheet 2)
D 240101

D 240102 x 90
200
D 240103 y 9787
100
D 240104

D 240105

D 240106

D 240107 z 8897
200
D 240108

D 240109

D 240110 a 45
640
D 240111

(blank row)
S 240229 j 4545
100
S 240230

S 240231

S 240232 k 544545
200
S 240233 l 454556
124
S 240234

S 240236

S 240237

S 240238 m 45456
135

Possible ranges are 240101 - 240199 and 240229 - 240285.

Any help would be greatly appreciated!!!