Automatic entry of repetetive data

[Clueless in Seattle]

I kept a log of all my expenses in an Excel 97 worksheet.

One of the items that I enter over and over is state sales tax, and
each time I enter sales tax I also enter the categories the expense
falls into like this:

Column1 | Column2 | Column 3 | Column 4
| | |
sales tax | taxes | state | sales

I enter each of those items into a separate column.

Is there a way to automate the entry in columns 2,3 & 4, so that when I
starte to type "sales tax" in column 1, Excel will automatically fill
in columns 2, 3, and 4?

 

[Don Guillett]

Sure, you can use a worksheet_change event

if target.column<>1 then exit sub
target.offset(0,1)=taxes
etc

 

[Anne Troy]

Or you can create a table of your entries, and use a vlookup. For a
tutorial:
http://www.officearticles.com/tutorials/order_form_or_invoice_form_in_microsoft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com

 

[Clueless in Seattle]

Thanks Don And Anne for the rapid responses to my query!

Trouble is, I can't make heads or tails of what you guys wrote.

Can you point me to a tutorial or two that I could study so that I
could understand the suggestions you guys made?

Or, do you know if there's an Excel group for "dummies"?

Will Anderson in Seattle
a.k.a. "Clueless"

 

[Clueless in Seattle]

Thanks Don And Anne for the rapid responses to my query!

Trouble is, I can't make heads or tails of what you guys wrote.

Can you point me to a tutorial or two that I could study so that I
could understand the suggestions you guys made?

Or, do you know if there's an Excel group for "dummies"?

Will Anderson in Seattle
a.k.a. "Clueless"

 

[Anne Troy]

Will, I did provide a link to a tutorial. What I suggest is that you follow
the steps exactly, using OUR sample. By the time you have done that, you
should be able to do it again using your own data.
*******************
~Anne Troy

www.OfficeArticles.com