LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Find a row and a specific cell in that row


Hello,

I have a database in a worksheet with several columns (with headers).
From a VBA input sheet, I would like to be able to search a database
using the Last Name column - say column B - as my key search, locate
the row the Last Name is on, and go to a specific cell on that row -
say in column P - and edit the data in that cell. I'm sure this is
child's play for some of you but I have not had any luck so far with
the right code.

Any help in this regard would be greatly appreciated.

Thanks in advance,

Glenn P


--
Glenn P
------------------------------------------------------------------------
Glenn P's Profile: http://www.excelforum.com/member.php...o&userid=23595
View this thread: http://www.excelforum.com/showthread...hreadid=377601

 
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
Find a specific formatted string in a cell KCK Excel Worksheet Functions 1 April 16th 08 09:16 PM
Find specific cell value nathan Excel Programming 3 January 12th 05 06:03 PM
Find last cell in a specific column Eva Shanley[_2_] Excel Programming 2 September 8th 04 09:01 PM
How to find and sub total a specific number of cell above the target cell jane Excel Programming 1 January 21st 04 03:37 PM
use find twice to find cell on a specific row captbluefin[_6_] Excel Programming 2 November 1st 03 08:22 PM


All times are GMT +1. The time now is 07:22 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"