| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to generate a text file from Excel using a macro or script? | Excel Discussion (Misc queries) | |||
| How to generate a text file from Excel using a macro or script? | Excel Discussion (Misc queries) | |||
| How do I write a script to add space between numbers in a column? | Excel Discussion (Misc queries) | |||
| VB Script Regular Expressions - Missing | Excel Discussion (Misc queries) | |||
| Script to add hyperlink to Excel cell containing text | Excel Programming | |||
Threaded Mode
