|
|
#6
06-28-2011, 10:15 AM
|
|||
|
|||
Hi
I tested the macro it it seemed to work fine for me. If I understand you correctly it should do the following: 1. As Cell A6 is blank it should copy the contents of Cell A5 into Cell A6. 2. As Cell A11 and A12 are blank then copy the contents of Cell A10 into Cells A11 and A12. and so on.................. The macro will run for 1000 lines. So Cell A30 will be copied to Cells A31 through A1000. If this is not what you want then please explain what you expect to happen and I will see what I can do. Tony(OTPM) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Move data from 1 cell to another cell | Catalin.B | Excel | 1 | 06-25-2011 12:51 PM |
| How to fill a cell with random numbers to do calculations? | zanat0s | Excel | 1 | 06-13-2011 10:33 AM |
 How to combine different cells data in one cell?
|
Learner7 | Excel | 1 | 07-28-2010 12:07 PM |
| How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
| Automatically entering/fill data in cells in Excel 2003 | dipdog | Excel | 0 | 08-17-2006 08:37 AM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode