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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Worksheets
How can I locate a value in a worksheet but among
multiple worksheets. I don't want to use find&replace from edit menu. I prefer to use a function such as vlookup, match etc.. I appreciate your help |
#2
|
|||
|
|||
Worksheets
Mike,
Excel doesn't provide a lot of functionality for working across multiple worksheets. It may be that my standard rant about putting the data in a single worksheet (with additional columns as necessary, to differentiate stuff) is indicated. People often split data into separate worksheet, and miss out on a lot of Excel functionality. Tell us more about the data in the sheets. Be specific. This may not sit well, but my be just what you need in the long run. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Mike Psarras" wrote in message ... How can I locate a value in a worksheet but among multiple worksheets. I don't want to use find&replace from edit menu. I prefer to use a function such as vlookup, match etc.. I appreciate your help |
Thread Tools | |
Display Modes | |
|
|