ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data searching between sheets (https://www.excelbanter.com/excel-discussion-misc-queries/54674-data-searching-between-sheets.html)

YJL

Data searching between sheets
 

I want to make language libruary where I can retrieve all my past
entries in tow different sheets. When I type keywords into the
self-made searching box, the corresponding results will show up. (Not
excel built-in search function Ctr-F please!!!! )

Anybody out there can give me direction where should I get started??

Please Help!!!

Thanks


--
YJL
------------------------------------------------------------------------
YJL's Profile: http://www.excelforum.com/member.php...o&userid=28693
View this thread: http://www.excelforum.com/showthread...hreadid=483776


pameluh

Data searching between sheets
 
Eeek.... Try a vlookup

"YJL" wrote:


I want to make language libruary where I can retrieve all my past
entries in tow different sheets. When I type keywords into the
self-made searching box, the corresponding results will show up. (Not
excel built-in search function Ctr-F please!!!! )

Anybody out there can give me direction where should I get started??

Please Help!!!

Thanks


--
YJL
------------------------------------------------------------------------
YJL's Profile: http://www.excelforum.com/member.php...o&userid=28693
View this thread: http://www.excelforum.com/showthread...hreadid=483776



Norman Jones

Data searching between sheets
 
Hi YJL,

See responses in Programming and Excel.

---
Regards,
Norman



"YJL" wrote in message
...

I want to make language libruary where I can retrieve all my past
entries in tow different sheets. When I type keywords into the
self-made searching box, the corresponding results will show up. (Not
excel built-in search function Ctr-F please!!!! )

Anybody out there can give me direction where should I get started??

Please Help!!!

Thanks


--
YJL
------------------------------------------------------------------------
YJL's Profile:
http://www.excelforum.com/member.php...o&userid=28693
View this thread: http://www.excelforum.com/showthread...hreadid=483776





All times are GMT +1. The time now is 11:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com