How do i fill the details to next sheet using the fomrs

Hi ,

I am looking to creat a forms where i will have a set of details against which the details needs to be filled and that details get updated to the next sheet.

Attaching my requirement.

Green Marked details is fixed and Yellow marked details are manul upodating and this should be updated to sheet2.

When the details get updated it has to do a calculation.
1)Gross Bill Amount =Gross Product Amount(Per Piece)*Number Of Product
2)Net Bill Amount =Gross Bill Amount*Fright and Handling Charges+Gross Bill Amount


Regards,
Vijeth

Maybe:

Please Login or Register  to view this content.

Hi John,

thank you for the above code. But i realy do not have the expertise to use this. Could you please fil that in excel and upload ?

Ok. Try this. See if it does what you need.

Excellent !!...Really Very thank full.

You're welcome. Glad to help out and thanks for the feedback.