| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need macro to check if cell is not blank & previous cell is blank, copy information from row above & paste
I am attempting to take data that looks like this.
A B C D E F 125.06 3.12 26.05 2/5/2007 7/1/2007 0.2 0.2 0.2 Look for if there is any data in Col F (data is variable) and Col E is blank then copy the previous Row's data A-E and paste it in the next row. So it then looks like this. A B C D E F 125.06 3.12 26.05 2/5/2007 7/1/2007 0.2 125.06 3.12 26.05 2/5/2007 7/1/2007 0.2 125.06 3.12 26.05 2/5/2007 7/1/2007 0.2 Any help with this would be great! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If blank cell, copy information from cell above | Excel Worksheet Functions | |||
| Macro to copy previous row and insert two blank rows | Excel Discussion (Misc queries) | |||
| 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) | |||
| Copy & paste cell after inserting blank row | Excel Programming | |||
Threaded Mode
