PDA

View Full Version : Selected Sheet Range copy One after One!



r_know
04-24-2014, 11:44 AM
Dear All,

I want export content as defined Range with following,

1. In Index sheet I have button where I want except Index sheet other sheets name shows in Userform. So I can choose from userform sheet which need to find range for export.
2. After selection sheet, each selected sheet B1 to O column last row criteria to find last row.
3. But Range copy B1 to P column based on O last row.
4. This range copy to new workbook; Paste in B1 as same format & Value (no formula)
5. Once first sheet pasted and second sheet criteria same B1 to O column last row criteria to find last row.
But Range copy B1 to P column based on O last row.
6. This copied in just below the last row of earlier pasted portion.
7. All selected sheet copied/pasted one after one in one sheet.

Can someone figure out? Thanks for your time

Reg, RL11600

r_know
04-25-2014, 06:07 AM
Can Any One Pls?

snb
04-25-2014, 07:12 AM
Maybe here:

solutions (http://www.excelforum.com/commercial-services/)