copy summary data to new sheet

[ritati]

Hi All,
Please help me, need a macro to make reverse direction,
from database sheet make summary as invoice form.
attached sample file to understand my request
thank in advance

[taps]

Hi,

Please mention an example how you want the data in Invoice Master sheet. Also how that particular data is appearing in other three sheets.

Regards
taps

[ritati]

Attached Again:
in Invoice Master (Sheet) noted from where should retreive values,
and added sheet "Invoice Master (Example) include how data would be from first invoice in Invoice_Data"

Thank You

[taps]

Hi,

I have slightly modify the Invoice format structure which you can easily remove during printout (if required) by changing the print area.
Check the Invoice Master Final sheet. Hope it will help you.
If you change the cell C19 with the Invoice no. (Invoice Master Final sheet) then the data will get updated with new values.

Best of Luck!!
taps

[ritati]

Thank you a lot Taps,