merging worksheets with repetition.

[maheshwow]

Below is the code to merge all wroksheets in a workbook. Code: If sh.Name <> DestSh.Name Then calls for all sheets except output sheet to be merged.
Please help to modify this code to merge sheet with names in "Summary" page "Column-A". Also each sheet should repeat entry as per qty in "Column-B" of Summary page.

Summary Page eg:
ColumnA ColumnB
Sheet1 2
Sheet2 1
Sheet3 5

in this case, Sheet1 sould copy itself 2 times, Sheet2 1 time & Sheet3 5 times in the output sheet.

Please Login or Register  to view this content.

this is a repost since my old query is unanswered. Should i tag my old post as "Solved"?

[pike]

maheshwow , unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

Bump your other thread to bring it to the top of the list