Data Sorting?

[Tim]

I do a monthly ledger where I categorize items like groceries,
restaurants, and gas. In each row, there is a cell for "transaction
description" such as Kroger or Publix. . The cell next to this is my
category cell where I have codes like "g" for grocery and "r"
for restaurants, etc. I am trying to figure out a way for Excel to read
the contents in the transaction description cell and put the correct
code in the adjacent cell.

For example, I have Kroger and Publix for groceries. I wanted excel to
see those words and put a "g" in the category cell next to it on
the same row. The final product is that I total all of the rows for
each category and these totals go into a year end spread sheet. This
happens every month, so I would like to be able to make a macro for it.
Would anyone have a suggestion on how to do this? This is on Excel 2004
(v11.2) using Mac 10.4.2.

 

[Bob Greenblatt]

I do a monthly ledger where I categorize items like groceries,
restaurants, and gas. In each row, there is a cell for "transaction
description" such as Kroger or Publix. . The cell next to this is my
category cell where I have codes like "g" for grocery and "r"
for restaurants, etc. I am trying to figure out a way for Excel to read
the contents in the transaction description cell and put the correct
code in the adjacent cell.

For example, I have Kroger and Publix for groceries. I wanted excel to
see those words and put a "g" in the category cell next to it on
the same row. The final product is that I total all of the rows for
each category and these totals go into a year end spread sheet. This
happens every month, so I would like to be able to make a macro for it.
Would anyone have a suggestion on how to do this? This is on Excel 2004
(v11.2) using Mac 10.4.2.

While you could use a macro, instead, look into VLOOKUP in Help. You can
place a formula in these cells that will generate the correct code.