Go Back  DVD Talk Forum > General Discussions > Tech Talk
Reload this Page >

Anyone up for an MS Excel project?

Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

Anyone up for an MS Excel project?

Old 02-07-03, 09:15 PM
  #1  
DVD Talk Gold Edition
Thread Starter
 
Join Date: Oct 2000
Location: Wilmington DE
Posts: 2,651
Likes: 0
Received 0 Likes on 0 Posts
Anyone up for an MS Excel project?

Making a client database for all the customers a company deals with.


First page (worksheet) is simple ehough:

It lists the name, phone number, last appointment date, etc,etc

Now, how can I make each item in the "name" category" LINK to another worksheet?

So, if I click on the name 'John Smith' in the name category, it will automatically go to 'worksheet 3' which lists all his stats and information


Anyone got any tips so far?
Old 02-07-03, 09:17 PM
  #2  
X
Administrator
 
X's Avatar
 
Join Date: Oct 1987
Location: AA-
Posts: 10,763
Likes: 0
Received 4 Likes on 3 Posts
Excel is not a database. Try Access.
Old 02-07-03, 09:29 PM
  #3  
DVD Talk Gold Edition
Thread Starter
 
Join Date: Oct 2000
Location: Wilmington DE
Posts: 2,651
Likes: 0
Received 0 Likes on 0 Posts
Originally posted by X
Excel is not a database. Try Access.
Person wants to use Excel

If I could get past the "linking a cell to a worksheet" issue, I would be moving along much faster

Can you explain that to me?
Old 02-07-03, 09:30 PM
  #4  
X
Administrator
 
X's Avatar
 
Join Date: Oct 1987
Location: AA-
Posts: 10,763
Likes: 0
Received 4 Likes on 3 Posts
I don't do Excel.
Old 02-07-03, 10:22 PM
  #5  
DVD Talk Hall of Fame
 
Join Date: Oct 1999
Location: not CT
Posts: 9,618
Likes: 0
Received 0 Likes on 0 Posts
1 worksheet per person? How many clients are there? I do believe Excel would burst into flames if you tried to manipulate something designed like that, espescially if it is large.

As for the linking to and opening up of another worksheet, well, I'm 89% sure that that would require some sort of Visual Basic macro. You would basically have to put a little button next to each name that is programmed to open up a new window with the relevant sheet.

The other option would be to put everyones info into one worksheet of enormous proportions and then use a macro pulldown menu and vlookup to bring up names and info.

It doesn't look promising.
Old 02-08-03, 12:48 PM
  #6  
Senior Member
 
Join Date: Jun 2001
Location: Hail to the Victors!
Posts: 337
Likes: 0
Received 0 Likes on 0 Posts
It really isn't that difficult. As BigPete said, you are goin to need to use a macro to do this. with excel, recording macros is relatively painless, all you have to do is click the "record macro" button, and perform the operations you will like the macro to do.

After this, create a button (or link it to a cell) under the define macros menu, and you should be good to go. This does get tedius if you have lots of macros, and you may want to consider Access. But good luck, and let us know if this doesn't work.
Old 02-09-03, 01:33 AM
  #7  
New Member
 
Join Date: Aug 2002
Posts: 15
Likes: 0
Received 0 Likes on 0 Posts
The simplest is to use a Hyperlink. (no macro involved)

1. Go to your first worksheet or first page
2. Select Insert from your menu
3. Select Hyperlink
4. On the left of the dialog box, select "place in this document"
5. On the text to display, type the name of the person
6. on the cell reference, select the sheet you want to go to when the link is clicked.
7. click on OK and you're done.

hope that helps. btw, i'm using excel 2000

you might want to rethink the solution if you are looking at maybe 500 or 1000 names.

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.