Hi All,
I need help to create macro where i have 10 columns and 300 rows. In column 5 i have unique data so i want if i give unique name from column 5 in text box then data corresponding to column 1 and column 4 reflects in another sheet.
Eg: [TABLE="border: 0, cellpadding: 0, cellspacing: 0"]
[TD="width: 64"]name[/TD]
[TD="width: 64"]class[/TD]
[TD="width: 64"]number[/TD]
[TD="width: 64"]age [/TD]
[TD="width: 80"]percentage [/TD]
[TD="width: 64"]address[/TD]
vb
[/td]
[TD="align: right"]45[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]62[/TD]
[TD="align: right"]12[/TD]
sds
[/td][/tr][tr][td]df
[/td]
[TD="align: right"]456[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]12[/TD]
fdsf
[/td][/tr][tr][td]rt
[/td]
[TD="align: right"]45[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]12[/TD]
dfew
[/td][/tr][tr][td]rtr
[/td]
[TD="align: right"]45[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]19[/TD]
fdsf
[/td][/tr][tr][td]qwe
[/td]
[TD="align: right"]568[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]12[/TD]
fdsf
[/td][/tr][tr][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr][tr]
[TD="colspan: 4"]In another sheet I want (if name=rtr)[/TD]
[TD="align: right"]45[/TD]
class
[/td][td][/td][td][/td][td][/td][td][/td][/tr][tr]
[TD="align: right"]12[/TD]
[TD="colspan: 2"]percentage[/TD]
[TD="align: right"]10[/TD]
number
[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/TABLE]
So i can use two ways:
a) create macro to filter data and copy corresponding column data
b) Search unique data and paste corresponding data
please help me to code this one
Im new to VBA