View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nick Nick is offline
external usenet poster
 
Posts: 20
Default 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