How to search for all matching entries in a column and copy cells to another sheet?

Gwip0102

New Member
Joined
Jun 11, 2009
Messages
1
Hello.

I have seen a number of threads on similar topics but i have struggled to adapt the code. any help would be appreciated.

Windows XP / Excel 2003

I am using one work book with 2 worksheets 'Interface' and 'Data'. - Data has 20,000 rows and works to column CJ.

I want to seach column Q of sheet data, for for a user defined variable (taken from a textbox 'txt_comcd' within worksheet 'Interface') If a match is found the following cells from that row would be copied:

Data O
Data Q
Data AC
Data AS

they would be copied into

Data O -> Interface B (row 10)
Data Q -> Interface C (row 10)
Data AC -> Interface F (row 10)
Data AS -> Interface E (row 1o)

it would then continue to find the next entry in Data Q and repeat the process - the cells would this time be copied into row 11, thus creating a list until there are no more matching entries in Data Q.

Reagards

Gwip
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Watch MrExcel Video

Forum statistics

Threads
1,099,164
Messages
5,467,006
Members
406,516
Latest member
richcresswell

This Week's Hot Topics

Top