Code to copy and paste those cells that have data

lostandcondfused

Guest

Posts: n/a

6th Jan 2009

I am looking for a VBA code that will allow me to select cells that only
contain data from sheet 2-9 and paste it in sheet 1. For example Sheet 2 has
data in Range A4:F9 and Sheet 3 has data in Range A4:F5 and I need that data
to be pasted into Sheet1. Are there any ideas on how to do this? I need
help.....

« RE: Sheet Naming | delete rows from an Advanced Filter range »

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 cells with data and paste	Thomp	Microsoft Excel Discussion	3	24th Apr 2009 09:49 PM
RE: Code to copy and paste those cells that have data	Mayte	Microsoft Excel Programming	0	6th Jan 2009 09:57 PM
copy & paste cells in Frontpage adds a zero to each line of code?	=?Utf-8?B?ZmlzaGVyd29tYW4=?=	Microsoft Frontpage	8	13th Feb 2006 08:19 PM
copy and paste between cells that have data	=?Utf-8?B?bXN0YWNr?=	Microsoft Excel Worksheet Functions	1	16th Nov 2005 09:16 PM
Copy and paste of sheets via VBA code that has merged cells	=?Utf-8?B?Sm9obiBDb3JiaW4=?=	Microsoft Excel Programming	3	19th Dec 2004 02:23 PM