Dear Experts,
I need a macro for performing an look up activity from a master sheet to a data sheet.
I have two work sheets 1.master 2.data
master sheet
Product_Code From Date To Date Type Revenue_%
ASP 01-01-08 01-01-09 New 20%
ASP 02-01-09 05-01-10 New 23%
ASP1 02-03-08 04-12-09 New 15%
ECQ 01-01-09 31-01-09 trail 20%
ECQ 01-02-09 28-02-09 New 21%
ECQ 01-02-09 28-02-09 Trail 22%
IN DATA SHEET
Product DATE Newbusiness% Trail%
ASP 05-01-08 20% 0
ASP 05-01-09 23% 0
ECQ 01-02-09 21% 22%
I need a macro by which looking up the date range, product, type it should pick the value from the master sheet and put in the data sheet where the header is Newbusiness% & for trail%
the data will be till the end of the sheet and master have approx 500 rows or above.
can anybody help me a code for this.
I need a macro for performing an look up activity from a master sheet to a data sheet.
I have two work sheets 1.master 2.data
master sheet
Product_Code From Date To Date Type Revenue_%
ASP 01-01-08 01-01-09 New 20%
ASP 02-01-09 05-01-10 New 23%
ASP1 02-03-08 04-12-09 New 15%
ECQ 01-01-09 31-01-09 trail 20%
ECQ 01-02-09 28-02-09 New 21%
ECQ 01-02-09 28-02-09 Trail 22%
IN DATA SHEET
Product DATE Newbusiness% Trail%
ASP 05-01-08 20% 0
ASP 05-01-09 23% 0
ECQ 01-02-09 21% 22%
I need a macro by which looking up the date range, product, type it should pick the value from the master sheet and put in the data sheet where the header is Newbusiness% & for trail%
the data will be till the end of the sheet and master have approx 500 rows or above.
can anybody help me a code for this.