Automatic entry of repetetive data

  • Thread starter Clueless in Seattle
  • Start date
C

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?
 
D

Don Guillett

Sure, you can use a worksheet_change event

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

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"
 
C

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"
 
A

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
 
Top