Copy rows onto existing sheet / start a new sheet if full

mg_sv_r

Guest

Posts: n/a

29th Nov 2007

Hi

Could anyone help me with a macro that will copy all rows of one worksheet A
onto worksheet B but if worksheet B becomes full, start a new worksheet
appending a letter or number to the worksheet name?

Thank you in advance for any help.

Regards
John

« subtracting one csv file from another | ThisWorkbook.Path & Windows Vista »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copy rows from one Data sheet to another sheet based on cell conte	John McKeon	Microsoft Excel Misc	2	15th May 2010 06:49 AM
Search for rows in one sheet and copy into another sheet based on customer id	chitiksha@gmail.com	Microsoft Excel Worksheet Functions	1	22nd Oct 2007 03:09 AM
Help: auto-copy entire rows from 1 sheet (based on cell criteria) to another sheet.	bertbarndoor	Microsoft Excel Programming	4	5th Oct 2007 04:00 PM
'Copy to' Advance Filter depend only on sheet ID not start sheet	=?Utf-8?B?U2FuZHkgWWF0ZXM=?=	Microsoft Excel Worksheet Functions	0	4th Apr 2006 03:48 AM
Copy the entire sheet to overlay existing sheet?	LurfysMa	Microsoft Excel New Users	2	29th Aug 2005 07:05 PM