G
Guest
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?
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?