How can I fill the below emty cells with above cell data?

Learner7 · #7 06-28-2011, 11:55 AM

Quote:

Originally Posted by OTPM

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)

Yes. You are right. That is what I want. But when I tried it to copy the blank cells by dragging A5 Cell, it copies as follows:

CopyDataToCell-5
CopyDataToCell-6
CopyDataToCell-10
CopyDataToCell-11
CopyDataToCell-12

Actually it should copy:

CopyDataToCell-5
CopyDataToCell-5
CopyDataToCell-10
CopyDataToCell-10
CopyDataToCell-10

Where I am doing wrong in executing the function. Please help.

Thanks.

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