So you want this data (322200894861) to be entered in a cell automatically,
and once it's entered, not to be changed? Well, I still say you will need
either macors or circular references for this effect. You could do it
manually by typing the number in then protecting the worksheet....

So, what should the file look for to trigger poplating the cell? Will it be
only one cell, or a column of cells, one populating after the other?

"WiredMike" wrote:

It will pull from a cell containing the date, a part number, and a detail
number.
Example: 322200894861 3/22/2008 is the date 948 is the part number and 61
is the detail number.
This information will all go into one cell. After the first user completely
fills out the rest of the sheet. He will be sending the file to other users
in the company. This is where I need to keep the information the same no
matter how many times the file is opened.