On 18 Apr, 12:05, "Mark Ivey" wrote:
K,

If you can do the same with this file (upload it for me to review it), I
will see if I can provide a fix for it.

BTW - would you mind taking a minute to rate the results you are getting
from the people that do help you out...

Mark Ivey

"K" wrote in message

...



ROW * * A * * * * B * * * *C * * * D * * * * * E * * * * F--col
1 * * * * CODE * CO * * *AC * * FO * * * CR (-) * *DR (+)
2 * * * * * 1LD * * *M * * * X1 * * GGG * -1000 * * 2000
3 * * * * * 1LD * * *M * * * X1 * * GGG * -2000 * * 4000
4 * * * * * 1LD * * *M * * * X2 * * SSS * *-300 * * * 500
5 * * * * * 4EN * * *G * * * X2 * * SSS * *-4000 * * 8000
6 * * * * * 4EN * * *G * * * X2 * * SSS * *-5000 * * 10000
7 * * * * * 4EN * * *S * * * X3 * * TTT * * *-6000 * * 12000
8 * * * * * 3CO * * *S * * * X3 * * TTT * * *-7000 * * 14000
9 * * * * * 3CO * * *S * * * X4 * * SSS * * -8000 * * 16000
10 * * * * 3CO * * *S * * * X4 * * SSS * * -9000 * * 18000

In Sheet2 I got spreadsheet template setup (see below)

ROW * * A * * * * * B * * * * *C * * * * D * * * *E * * *F * * * *G--
col
1 * * * * *REF * * * *CR * * * *CR * * * CR * * *DR * DR * * *DR
2 * CO-AC-FO * * 1LD * * * 3CO * * 4EN * *1LD * 3CO * 4EN

I want macro which should produce result like this in Sheet2 from
Sheet1 (see below). Please if anybody can help

(Shee2)
ROW * * A * * * * * B * * * * C * * * *D * * * E * * * *F * * * G--
col
1 * * * *REF * * * * *CR * * * CR * * *CR * * DR * * DR * * DR
2 * CO-AC-FO * * 1LD * * *3CO * *4EN * 1LD * *3CO * 4EN
3 * M *X1 *GGG * -3000 * * * * * * * * * * * *6000
4 * M *X2 *SSS * *-300 * * * * * * * * * * * * *500
5 * G *X2 *SSS * * * * * * * * * * * * *-9000
18000
6 * S *X3 *TTT * * * * * * * * * * * * * *-6000
2000
7 * S *X3 *TTT * * * * * * * * *-7000 * * * * * * * * * * 14000
8 * S *X4 *SSS * * * * * * * *-17000 * * * * * * * * * *34000

basically macro should look in Sheet1 Data and then make result like
above- Hide quoted text -

- Show quoted text -

sorry Mark i never realised that i can rate someone aswell. i'll do
that from now on. Thanks for the help as joel has solved my prolem. i
must say i am learing quite lot from you all. thank for all knowledge