Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match Values and Copy Rows
Hi all, I have two Sheets in a Workbook. One Sheet name is "Data" and
the other Sheet name is "Search". In Sheet "Search" I have three TextBoxes and in top cell of each TextBoxe I have put headings like, TextBox1 heading is "Serial" , TextBox2 heading is "Record" and TextBox3 heading is "Quantity". In Sheet "Data" i have data from Column A to Column F. In Column A i put "Serials" , in Column B i put "Record no." and in column C i put "Quantity". In other Columns (D to F) i have text and other sort of data. I want macro on a button which should check values in each TextBox of Sheet "Search" and match those values in Columns A to C of Sheet "Data" and if that value string match then macro should copy that row from Column A to Column F of Sheet "Data" into Sheet "Search" For example if i put value "334" in TextBox1 and "SC0001" in TextBox2 and "45" in TextBox3 then macro should match TextBox1 value in Column A of Sheet "Data" and TextBox2 value in Column B and then TextBox3 value in Column C and if all three values get matched in Sheet "Data" columns on same row then macro should copy that row into Sheet "Search". I hope i was able to explain my question. Is there any friend can help me on this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Values based on a Match Q | Excel Programming | |||
Match and copy rows from 2 sheets | Excel Programming | |||
Match Values in Rows with Partial Values in Columns | Excel Worksheet Functions | |||
copy rows that do not match values in dynamic range. | Excel Programming | |||
How do i compare values from two sheet and copy & paste if values match? | Excel Programming |