Automatic entry of repetetive data

  • Thread starter Thread starter Clueless in Seattle
  • Start date 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?
 
Sure, you can use a worksheet_change event

if target.column<>1 then exit sub
target.offset(0,1)=taxes
etc
 
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"
 
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"
 
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
 
Back
Top