I work for a construction company where we do a lot of bidding on projects.
We have an excel spreadsheet of about 150 different categories that could be
in a bid, but most of the time only 20 or so are used. However, every bid
consists of different categories. Instead of typing out the category every
time, a co-worked told me that before they updated to Microsoft Office 2002,
she used to be able to type in (*02), or (*04), (*63), whatever no. the
category was that she wanted, and the category name would appear in the cell.
She asked me if I could make it like that again because it was much easier
on her. Does anyone know how to go about setting that up?