Want a simple Macro to move a cell down from a current cell

[hariarahul]

hello friends,

i am very much new to the macros. i am having a problem recording a macro hope u could help me out.

i have quantity in one cell n the rates below that in many rows now i want to calculate the value of the quantity by multiplying it with the last rate

i need an output in such a way that when i enter a new rate in the row at the last n then run the macro the result should be quantity multiply by the rate which i have entered last ie the last entry made by me in the bottom.

hope u understand my problem i am developing a sheet based on this

thanks for the help

[pooja_deshpande]

only one line of code is required
select your quantity cell.
assuming that rates begin from immediately below this cell,

Please Login or Register  to view this content.

[pooja_deshpande]

You can even use an excel formula.
Suppose your qty is in A1.
Rates begin from A2 onwards.
Put this formula in B1.

=A1* OFFSET(A1,COUNTA(A2:A500),0)

[hariarahul]

Thank u very much pooja for ur quick reply its working

[pooja_deshpande]

glad to be of help.
please mark this thread as solved if you are satisfied with the results.

[hariarahul]

hey pooja thanx once again now i have a bit more query hope so u can help me out but for that i will have to send u a excel file so can u provide me ur email id or can u mail me at hariarahul at gmail dot come

thanx