save nul value. but it is not save in same rows....

[krunal.pa]

when i try to save data in other sheet. it is save but, if middle name is null in last record. then after i save other record the data is not save in same row.

i also want "sr.no" come automatically form data..

for.ex.

if in sheet2 last "sr.no" is "7" then it automatically display "sr.no" "8" in sheet1

please help me

[:) Sixthsense :)]

Try this...

Please Login or Register  to view this content.

[krunal.pa]

if i entered value on different cell and i want to save in single row..... then?

ex..

i enter value in b14, g14 , c5 , d9 and i want that value in second sheet...

like sheet1-b14 goto sheet2-c4
sheet1-g14 goto sheet2-d4
sheet1-c5 goto sheet2-e4
sheet1-d9 goto sheet2-f4

[:) Sixthsense :)]

In that case you go ahead with your method like this...

Please Login or Register  to view this content.

[krunal.pa]

Thanks dear,

but one more thing, how to i display sr.no. Automatically in sheet1?
It automatically find last record in sheet2 and it automatically display next no.

For. Example..

If in sheet2 last no is 7 then it automatically dispaly no 8 in sheet sr.no. Cell.

[:) Sixthsense :)]

In the suggested code the below line doesn't solve that problem?

Please Login or Register  to view this content.

[krunal.pa]

Thanks dear again...

[krunal.pa]

Dear one more thing

i also want to display one message after save data. "save record" for confirmation.

[:) Sixthsense :)]

Add this line before end sub

Please Login or Register  to view this content.