Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search for Quote
http://www.rondebruin.nl/copy5.htm
the above site has plenty of sample code on using autofilter. While it isn't specific to your situation, it should be easy to adapt to what you ask for. -- Regards, Tom Ogilvy "Andri" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search for Quote
Dim LastRow As Long
Dim rng As Range LastRow = Cells(Rows.Count, "A").End(xlUp).Row Set rng = Range("A2").Resize(LastRow - 1) rng.AutoFilter Criteria1:="=" & Range("A1").Text, field:=1 -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Andri" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using a single quote ' in SEARCH function | Excel Worksheet Functions | |||
Removing leading single quote (') from cells with Search/Replace | Excel Discussion (Misc queries) | |||
We are looking for a quote log. | Excel Discussion (Misc queries) | |||
Typing a quote character Vs pasting a quote character= what happens to the resulting CSV? Interesting!! | Excel Programming | |||
Typing a quote character Vs pasting a quote character= whathappens to the resulting CSV? Interesting!! | Excel Programming |