Copy from worksheet if cell is blank

Jeff Gross

Guest

Posts: n/a

1st Jun 2009

Hi-

I have 300 rows of data possible on sheet2 (variable). Column A on sheet2
is currently blank. The data starts in column B of sheet and is the result
of an "IF, Then" formula.

What I need the code to do is starting with A2, look for data in B2 and if
the result of the IF/Then statement in B2 results in a blank cell, go to the
next row and repeat for row 3. If there is data in B2, copy a cell from a
different worksheet into this cell and then continue on to row 3.

Thanks, Jeff.

« Re: Create a Month's Sheets automatically | linechart through vb script »

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 cell value into blank cells below (full worksheet)	SimmoG	Microsoft Excel Worksheet Functions	4	3rd Jun 2009 11:03 PM
Copy a mamed range in one worksheet to the first blank cell in a c	Philip J Smith	Microsoft Excel Programming	5	28th May 2009 09:25 AM
Need macro to check if cell is not blank & previous cell is blank, copy information from row above & paste	JenIT	Microsoft Excel Programming	4	12th Apr 2007 08:56 PM
Copy to first Blank cell in Colum C Non blank cells still exist be	=?Utf-8?B?VWxyaWsgbG92ZXMgaG9yc2Vz?=	Microsoft Excel Programming	2	8th Oct 2006 07:35 PM
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C.	=?Utf-8?B?UVVFU1Q0MTA2Nw==?=	Microsoft Excel Misc	1	15th Jan 2005 09:29 PM