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

You have asked this question many times.
The answer is NO
One workbook has to be the master and the others can be updated from it.

I suppose you could have a Master file that looks at all other files and no
one every enters data in Master

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Erin Kinsella" wrote in message
...
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

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