LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 236
Default Find instances of value in another sheet, copy row and highlight cells

Google: "How do you store data in Excel as a database?" In this
newsgroup.

If you have a recent version of Excel and if you know how to build a
SQL JOIN statement you can do what you want.

The post I referred you to has the syntax you'll need to select from
the two sheets.

You may have to have headers on row 1. Good luck.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shift + arrow to highlight and copy cells podbay New Users to Excel 2 September 25th 09 04:21 PM
Shift + Arrow to highlight and copy cells podbay Excel Discussion (Misc queries) 2 September 25th 09 04:16 PM
How do I highlight 'Delete sheet' in cells group. globusoculus Excel Worksheet Functions 1 November 17th 07 11:22 PM
Find all text instances in a sheet and add one number from each row Greg Excel Discussion (Misc queries) 1 January 31st 05 11:45 PM
Search, find, copy muliple cells from new sheet and paste Graham[_5_] Excel Programming 3 December 29th 03 07:38 PM


All times are GMT +1. The time now is 04:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"