PDA

View Full Version : copy summary data to new sheet



ritati
12-02-2012, 10:36 AM
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
12-04-2012, 02:01 AM
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
12-04-2012, 02:34 AM
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
12-06-2012, 05:06 AM
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
12-06-2012, 09:47 AM
Thank you a lot Taps,