copy till last used range

**farrukh** · 03-02-2012, 08:46 AM

Hi All,

I need to copy range start every B2 and go to last used range then copy to another worksheet to starting paste range b6?

Thanks
farrukh

**tom1977** · 03-02-2012, 08:55 AM

something like this

Please Login or Register  to view this content.

**farrukh** · 03-02-2012, 09:33 AM

Tom1997,

It is copying the data in a row ? i need to do in a column range means column B range 2 is the start and go to last used range in the column B then copy to sheet2 on column B starting range 6?

Thanks
farrukh

**tom1977** · 03-02-2012, 09:47 AM

Could You send some excel file with sample

**farrukh** · 03-02-2012, 09:58 AM

Please find the attachment . In sheet2 i have paste the result that i need to ?

Thanks
farrukh

**tom1977** · 03-02-2012, 10:09 AM

try this

Please Login or Register  to view this content.

**farrukh** · 03-02-2012, 10:24 AM

Tom 1977,

Thanks works great !

Regards

copy till last used range

LinkBack

Thread Tools

Rate This Thread

Display

copy till last used range

Re: copy till last used range

Re: copy till last used range

Re: copy till last used range

Re: copy till last used range

Re: copy till last used range

Re: copy till last used range

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions