Hi All,
I am starting within a workbook with a standard invoice. During the course of a month this invoice will be copied within the workbook and the amounts changed each time.
Is there a way that I can:
a) Have amounts from 4 of the cells (say E11, E30, E43 and E75) within each new invoice worksheet automatically included on a summary page? These cells are calculated by formula.
and
b) Have each new invoice worksheet that is added (by copying) automatically have company name in a cell (say A3) and also re-named with company name.
Thanks in advance to anyone who can help me with this.
Bookmarks