Hi Erin

Are you trying to create a new invoice? If so, create a template with the
required info, excluding the invoice number, and save it as an .xlt. To
generate the invoice number, you will ideally use a macro, to generate a new
number every time you open the .xlt file, or everytime you wnat to save the
..xlt as a .xls.
hth

"Erin Kinsella" wrote:

I have a excel workbook with several worksheets. I am wondering if there is
a formula that I can put on a new worksheet that will allow certain
information that I put on another worksheet to automatically transfer to the
new worksheet. For example, on my worksheet is vendor id, phone, website and
then on the next row is invoice date, invoice #, description and cost. I
want a formula or something that will automatically transfer that data when I
enter it to a new worksheet. Is this possible?
--
Erin Kinsella