Excel VBA
 

Dear All,
i need a help for my one excel sheet to check and the
repeate the data no of times like.

orignal Data.

item bin Quntity shipt no. From
To

TL05SC1 T22M 2 001 1
2
TL05SC1 T23M 3 001 5
7

BRANCH
R1
R1

after Macro run the Result is. Sheet1 with 7 column and result on
Sheet2 with 5 columns

item bin quntity shipt no Carto
no.

TL05SC1 T22M 1 001
00100001R1
TL05SC1 T22M 1 001
00100002R1
TL05SC1 T23M 1 001
00100005R1
TL05SC1 T23M 1 001
00100006R1
TL05SC1 T23M 1 001
00100007R1

Thanks

Sajjad Ahme

--
Message posted from http://www.ExcelForum.com