I wanted to generate Vendor Invoice

[Sarfraz Khan]

Dear Sir,

Ref to attached sheet I want to generate Vendor Invoice as per mentioned format basis on data sheet.

my concern is once I put an Invoice number it should retrieve data as per attached sheet.

Please help.

 

[Hui]

Have a read of:
http://chandoo.org/wp/2011/11/18/formula-forensics-003/

 

[Nebu]

May be something like this

 

[sambit]

Hi Khan,
pl find attached file.