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
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