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
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
