| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from worksheet if cell is blank
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell value into blank cells below (full worksheet) | Excel Worksheet Functions | |||
| Copy a mamed range in one worksheet to the first blank cell in a c | Excel Programming | |||
| Need macro to check if cell is not blank & previous cell is blank, copy information from row above & paste | Excel Programming | |||
| Copy to first Blank cell in Colum C Non blank cells still exist be | Excel Programming | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
Threaded Mode
