Quote Originally Posted by sourabhg98 View Post
Why troubling yourself in typing all these manually.
Formulas can do that for you.

Main formula cell--H3
Each time you want to input labour rate, just copy the main formula cell and paste in the desired range.

=INDEX(INDIRECT("Sheet2!C"&MATCH(LEFT($B3,FIND("/",$B3)-1),Sheet2!$A:$A,0)&":C10000"),MATCH(RIGHT($C3,LEN($C3)-FIND("/",$C3)),INDIRECT("Sheet2!B"&MATCH(LEFT($B3,FIND("/",$B3)-1),Sheet2!$A:$A,0)&":B10000"),0))
The reason for this is because once a week I will generate a report from a program that will export into a new excel file. So I was going to try to create a tool in my toolbar that uses code that will refer to a separate file with all the Job and Labor type data. That way I can Change the data as needed and still be able to press a button in my toolbar for each report.

In my sample I am using two sheets, but it will really be two files. I was just trying to simplify it to get help and then later modify it to my needs.

Does this make sense?