A script to write in missing text
 

Example:

35395.0553 Amb Creamed Rice 425g 12 4150 1 7.69 1.
13 O/stock T
Rennie Peppermint 12's 36 45604 1
25.85 6.00 N/avail T
King Pot Chicken&Mushrm 12 49539 1 10.
89 1.18 N/avail T
4444.4444 Wrigleys Chewy 12 4150 1 7.
69 1.13 O/stock T
Rennie Peppermint 12's 36 45604 1
25.85 6.00 N/avail T
King Pot Chicken&Mushrm 12 49539 1 10.
89 1.18 N/avail T

Above is an example of how my report appears. As you can see there is only
one line of data in column A but B has three lines. What I need is a script
which writes in the number at the side of products so it will sort correctly.
So when I print the report it looks like this

35395.0553 Amb Creamed Rice 425g 12 4150 1 7.69 1.
13 O/stock T
35395.0553 Rennie Peppermint 12's 36 45604 1 25.85 6.
00 N/avail T
35395.0553 King Pot Chicken&Mushrm 12 49539 1 10.89 1.18
N/avail T
4444.4444 Wrigleys Chewy 12 4150 1 7.
69 1.13 O/stock T
4444.4444 Rennie Peppermint 12's 36 45604 1 25.85
6.00 N/avail T
4444.4444 King Pot Chicken&Mushrm 12 49539 1 10.89 1.
18 N/avail T

Any ideas?


--
Message posted via http://www.officekb.com