A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Find a value in multiple worksheets



 
 
Thread Tools Display Modes
  #1  
Old October 8th, 2003, 11:05 AM
Mike Psarras
external usenet poster
 
Posts: n/a
Default Find a value in multiple worksheets

First of all thank you for replying to my e-mail. As per
your request I will give you more details on what I want
to do.
Every day I pass the rates of currencies in a worksheet
and then I rename the worksheet tug giving that day's
date. So I have workbook with 30 or so (up to now)
worksheets with currencies and currencies' rates, and
every worksheet tug is renamed to i.e. 2-11-03, 3-11-03,
4-11-03 and so on.
When I want to find the mins or max value of a currency I
use the simple function i.e. =max(2-11-03:30-11-03!B1)
where B1 is the carrency rate I want to find. (Note that
the data is stored in exactly the same cells in every
worksheet).
For example:

A B
1 USD 1,1697
2 GBP 0,6124


On every worksheet in cell B1 I put the rate of USD.

In this way I get the max or min value of i.e. USD rate
but I cannot find in which worksheet it is located. And
as I have renamed the tugs of the worksheets in dates, it
will be very very helpfull to also see WHEN the rate of
USD reached its max or min value.

I hope all above is clear and I would appreciate if you
could find me a solution.
As I said in my first e-mail, I don't want to use
find&replace. I need a function...

THANKS AGAIN
..


 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:54 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.