I have to respond to this one...
You may not go through all the "trouble of creating the links", but by
the time you've clicked Edit | Find (Ctrl-F to the keyboard savy) and
typed in the name of the sheet (what was it called again?) - possibly
clicked find next several times...I would have clicked on the sheet,
found my information and closed it! Also for infrequent users of the
spreadsheet, they will be able to easily find their information. Might
even want to create a macro or link on the sheets to take you back to
the "home" page.
As demonstrated by the answers to this query, there are many solutions
each having pros and cons.
Is it Friday yet?
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ann Fisher
Sent: Tuesday, April 19, 2005 11:40 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Off Topic
It is a drop down "Within" Sheet or Workbook.
I wouldn't go through all the trouble of doing the extra worksheet and
doing links
Just at the top left hand corner cell A1 put the Name of the sheet
within the sheet the name of the tab and when you search the entire
workbook, it will go to that cell, unless there is another cell with
that exact name of the tab in it???
Ann Fisher
ERP Consultant
Manufacturing Solutions Group
Cell: (567) 204-3230
Fax: (949).341-4885
11678 Zerkle Rd., Lima, Ohio 45806
E-Mail: afisher@... <mailto:afisher@...>
600 South Highway 169 2000 Interchange Tower Minneapolis, Minnesota
55426
This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We cannot accept
liability for any loss or damage caused by software viruses.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Paul H. Smith
Sent: Tuesday, April 19, 2005 1:53 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Off Topic
I use the ctrl-f to search for data within the sheet but, I do not see
the
option extended options. Where might that be?
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf Of
Wayne Cox
Sent: Tuesday, April 19, 2005 1:40 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Off Topic
At 01:32 PM 4/19/2005, you wrote:
a
ctrl-F for find, and under the extended options, you can choose to
search
the entire workbook or just the current sheet.
-Wayne Cox
Twenty Three, Inc. -- Information Technology Consulting
828-685-2338
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
------------------------------------------------------------------------
----
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We cannot accept
liability for any loss or damage caused by software viruses.
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
You may not go through all the "trouble of creating the links", but by
the time you've clicked Edit | Find (Ctrl-F to the keyboard savy) and
typed in the name of the sheet (what was it called again?) - possibly
clicked find next several times...I would have clicked on the sheet,
found my information and closed it! Also for infrequent users of the
spreadsheet, they will be able to easily find their information. Might
even want to create a macro or link on the sheets to take you back to
the "home" page.
As demonstrated by the answers to this query, there are many solutions
each having pros and cons.
Is it Friday yet?
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ann Fisher
Sent: Tuesday, April 19, 2005 11:40 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Off Topic
It is a drop down "Within" Sheet or Workbook.
I wouldn't go through all the trouble of doing the extra worksheet and
doing links
Just at the top left hand corner cell A1 put the Name of the sheet
within the sheet the name of the tab and when you search the entire
workbook, it will go to that cell, unless there is another cell with
that exact name of the tab in it???
Ann Fisher
ERP Consultant
Manufacturing Solutions Group
Cell: (567) 204-3230
Fax: (949).341-4885
11678 Zerkle Rd., Lima, Ohio 45806
E-Mail: afisher@... <mailto:afisher@...>
600 South Highway 169 2000 Interchange Tower Minneapolis, Minnesota
55426
This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We cannot accept
liability for any loss or damage caused by software viruses.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Paul H. Smith
Sent: Tuesday, April 19, 2005 1:53 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Off Topic
I use the ctrl-f to search for data within the sheet but, I do not see
the
option extended options. Where might that be?
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf Of
Wayne Cox
Sent: Tuesday, April 19, 2005 1:40 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Off Topic
At 01:32 PM 4/19/2005, you wrote:
>This is an off topic question. I use an Excel spread sheet with aboutfor
>25-50 sheet in a workbook and I was wondering if you can do a search
>sheets in a workbook? Thanks in advance.What are you searching for? Specific data within any sheet? Just do
a
ctrl-F for find, and under the extended options, you can choose to
search
the entire workbook or just the current sheet.
-Wayne Cox
Twenty Three, Inc. -- Information Technology Consulting
828-685-2338
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
------------------------------------------------------------------------
----
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We cannot accept
liability for any loss or damage caused by software viruses.
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]