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: 66
Default Search for Quote

Dear All,

I have in sheet A, all the quotation about Parts. Which consist of fields
Part Number, description, unit price, Qty Offer, Remark (5 Fields).

then i would like to to display that quotation in Sheet B if i am entering
certain requested Part Number (the entry will be at A1)
Then the VBA code will display then starting Row 2, ALL RECORDS for the
requested Part Number.

Auto Filter is workable but i need the guidance by VBA.

Please guide how to implement it.

TIA,
Andri

 
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
using a single quote ' in SEARCH function ExTexan Excel Worksheet Functions 2 December 30th 06 01:11 PM
Removing leading single quote (') from cells with Search/Replace Arun Excel Discussion (Misc queries) 3 January 22nd 06 03:40 AM
We are looking for a quote log. Mitch Excel Discussion (Misc queries) 5 April 30th 05 05:22 AM
Typing a quote character Vs pasting a quote character= what happens to the resulting CSV? Interesting!! Tom Ogilvy Excel Programming 0 August 3rd 03 02:53 AM
Typing a quote character Vs pasting a quote character= whathappens to the resulting CSV? Interesting!! Jon Peltier[_3_] Excel Programming 0 August 3rd 03 02:22 AM


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