Microsoft excel macros Programing.
 

I, need help adding macros to a workbook, that has 135 worksheets. I want to
type 1 letter & 3 numbers to have a specific worksheet appear so that i would
be able to make data entries. These entries are being made on a daily basis,
and would be saved by date and phone number. If i wanted to retrieve a
particular client's information, I would just enter a phone # and the last
entry made for that client would appear.

Thank you

Roberto Torres

Microsoft excel macros Programing.
 

You really should be using a database by the sound of this.
Try MS Access or better still SQL server.
Things like this are far more simple in databases.

Nick



"Roberto Torres Perez" <Roberto Torres
wrote in message ...
I, need help adding macros to a workbook, that has 135 worksheets. I want
to
type 1 letter & 3 numbers to have a specific worksheet appear so that i
would
be able to make data entries. These entries are being made on a daily
basis,
and would be saved by date and phone number. If i wanted to retrieve a
particular client's information, I would just enter a phone # and the last
entry made for that client would appear.

Thank you

Roberto Torres