Excel worksheets

  • Thread starter Thread starter JohnnyB
  • Start date Start date
J

JohnnyB

I'm building a database where I have a master listing of
personnel that I can sort by office symbol. I want the
sections to update their respective worksheets and track
the changes to the master. Also, when I have new
personnel, I want to enter them on the master list and it
automatically goes to the respective worksheet. What can
be done to make this happen? Is there a formula or do I
need to create a macro? Also, I'm new to creating
macros, is there a book that will show me how to do this?
 
I don't think you can do what you want with formulas, so macros are probably
required. IF you're going to be using Excel a lot it is definitely worth
while to learn how to write macros. However, as with many things, there is
a learning curve. As for books, there are quite a few out there. You might
browse your local bookstore to see what they have. I doubt you'd find a bad
book on Excel macros but John Walkenbach's seem to be the most popular and
are very good in my opinion.
 
Back
Top