Hi Hectop, Thanks....
Hi Leith Ross,
Thanks....
I tried your code and its genarating a new workbook but with empty cells and showing a debug error... in below code...
and also tell me whether i can change the range from A1 to any cell range ie: H60, H61, H62 etc....
I have attached an excel.. which has a macro to organise a date from sheet1 to sheet2.... after organising data i need my desired range to be populated in a new workbook...
I have created the macro of my excel with help of forum guru (HaHoBe)......
where in sheet 2 my output range starts from B2 to H60 this is because the sample size i have mentioned in the excel so based on the sample size my range may vary from B1 to H60,H61,H62...etc....
Kindly come back if am not clear, request your support in accomplishing my need...
Kindly look into it.. and provide me a solution... Thanks...
Bookmarks