Hi Guys,
My source is Excel(.xls) file Worksheet1
COL1 COL2 COL3
US SALES 19
UK SALES 20
INDIA SALES 30
INDIA PUR 20
INDIA INV 50
CHINA SALES 15
IF I GIVE SEARCH PARAMETER AS "INDIA"
IT SHOUD POPULATE THE Worksheet2 WITH INDIA DETAILS
COL1 COL2 COL3
INDIA SALES 30
INDIA PUR 20
INDIA INV 50
Can some one tell me if this is possible with VB scripting in excel.
Regards
G
My source is Excel(.xls) file Worksheet1
COL1 COL2 COL3
US SALES 19
UK SALES 20
INDIA SALES 30
INDIA PUR 20
INDIA INV 50
CHINA SALES 15
IF I GIVE SEARCH PARAMETER AS "INDIA"
IT SHOUD POPULATE THE Worksheet2 WITH INDIA DETAILS
COL1 COL2 COL3
INDIA SALES 30
INDIA PUR 20
INDIA INV 50
Can some one tell me if this is possible with VB scripting in excel.
Regards
G