Excel file automatically entering string in cell for each row

[Drew]

I have a really simple Excel file that is being used for a Credit Card Log.
The user enters data for each purchase order, the data that is kept is,

PONum
PODate
POVendor
PODescription
POAmount
POObjectCode
POComplete (True/False)
POCarryover (True/False)

Each cardholder has their own file, and this file is processed into a SQL
Server database. I also need to store the a unique identifier for each
cardholder with each record.

How can I have Excel automatically fill in a cell with predetermined data
(can be on a different sheet) for each row that the user enters data on?

I hope I am clear enough, if not I can send a sample file (didn't know if I
should attach here).

Thanks in advance,
Drew Laing

 

[Earl Kiosterud]

Drew,

You can use Ctrl-apostrophe to repeat stuff from the cell above as you key
in a row. Or a macro could do it automatically.

Don't attach your file; many get agitated.

 

[Drew]

How can I make a macro do this for me?

Thanks,
Drew