I think may be you haven't got clear idea from my example. One column
contain Item size , another column in next row contain item name. The same
item size may be repeated for 100s of item. So if the same item size is
coming for following item, the item size will not be repeated for the item
under the same size. 1000's of item size may come. But the orginal excel will
be sorted acording to the size of the item.

I need to copy each size against each item ( each row) . many itemsize and
its item can be seen

Size item
A
1
2
3
B
4
5
6
Output

A
A 1
A 2 as follows

With thanks
Pol




"Jacob Skaria" wrote:

By unused cell I mean a cell out side this range...Try out entering the
formula in E2 itself copy the cell (not the formula..). Select your data
range ie Columna A. Use Go To window to select blanks and then PasteSpecial
formulas...

Even if you have an entire column of data this way works...

If this post helps click Yes
---------------
Jacob Skaria


"pol" wrote:

If the excel have 4000 or 5000 record it is not easy to do this by a user .
In the following example given , the unused cell is is A2..A3 and A5 .. A6
In a2.. a3 I have to copy XX and A5.. A6 I have to copy YY. So I think that
is not a solution for giving the equation ( =A1) from unused cell (a2) . The
copy and paste of this formula will not be wroked out.

With thanks for the reply.

Pol



"Jacob Skaria" wrote:

To do this you dont need a macro...

--Select a unused cell say E2
--Enter the formula in cell E2 which references the top cell (=E1)
--Copy the cell
--Keeping the copy select the data range in ColA (say A1:A100).
--Press F5. From Goto window select blanks
--This will select all blanks.. Now Right clickPasteSpecialFormulas. will
fill in with the data you need..
--Once done you can select col A Copy PasteSpecialValues to turn
formulas to actual values


PS: Post back if you still would prefer a macro

If this post helps click Yes
---------------
Jacob Skaria


"pol" wrote:

Please help with a macros to copy the data to acitve cell from the cell just
before the activce cell ( Only if the active cell is not null ). for example

type name
1 XX
2 xx1
3 xx2
4 YY
5 yy1
6 yy2

In the above example I want to copy XX from A1 cell to range a2..a3,
YY from A4 to copy to a4...a6. So I need to write the macro to copy
conditionally if the active cell is not null . The out put should come
type name
1 XX
2 XX xx1
3 XX xx2
4 YY
5 YY yy1
6 YY yy2
Please help

With thanks
Pol