about copy plz help

M

MAN3282

i have num in call A1 whan i push enter i want the same number in A2

how i can do it ??

thx
 
M

MAN3282

I'm sorry I must point out my question more

I'm have at approximately four thousand row in the first column there Bahey
figures

To be equivalent or any method urges When I click the introduction of the
figure in the row former replication

If the equation you must be introduced in each cell
No Warning only after the completion of these deficiencies and the problem


Thank you for assistance and I hope I explained my question and help me
 
G

Gord Dibben

Enter =IF(A1="","",A1) in B1

Select B1.

In NameBox type B1:B4000 and hit ENTER key.

CTRL + d to copy the B1 formula down to B4000


Gord Dibben MS Excel MVP
 
Top