Automatic entry of data in Excel column

[dr00bie]

I have a Credit Card Log that I am building in excel, and need to find out how to make Excel enter data into a column automatically.

The file is really simple, just a listing of all purchase orders in a billing cycle. I need the file to add certain data to A1 if a new row is started.

Is this possible?

Thanks,
Drew

 

[AnotherHiggins]

We need more information to help you. What 'certain information' do you want added?


[tt]_____
[blue]-John[/blue]
[/tt][red]"I'm against picketing, but I don't know how to show it."[/red]
-Mitch Hedberg

Help us help you. Please read FAQ181-2886 before posting.

 

[dr00bie]

Just 1 small piece of data. The filename of the excel file or if that isn't possible, the data can be keyed into the file on Sheet2.

The data is just the NT username, but it needs to be hard-coded, not programmatically found and entered.

Thanks,
Drew