tqm1
06-14-2007, 07:01 PM
Dear Experts
For index match, I am using following function, this works fine
=INDEX(Party!$B$2:$B$250,MATCH(Rpt_Daily!C6,Party!$A$2:$A$250,0))
source sheet=Party
Target Sheet=rpt_daily
Question-1
How to use above formula with command button.
I mean while pressing commandbutton, sheets("rpt_daily") must updated with sheets("Party")
Question-2
How to use above fourmat with offset() funciton?
Please help
For index match, I am using following function, this works fine
=INDEX(Party!$B$2:$B$250,MATCH(Rpt_Daily!C6,Party!$A$2:$A$250,0))
source sheet=Party
Target Sheet=rpt_daily
Question-1
How to use above formula with command button.
I mean while pressing commandbutton, sheets("rpt_daily") must updated with sheets("Party")
Question-2
How to use above fourmat with offset() funciton?
Please help