Hello,
Hi ppl I need your help once again in vba code to do the following
My requirement follows:
There are 4 different xl workbooks.
SaY Empdet.xls, rate.xls, value.xls, result.xls
Empdet.xls contains------> employee name, id, hours worked for each month(say oct09, nov 09, dec 09,.....dec 2012)
rate.xls contains-------> employee name,id, and the rate for each employee/hour
Value.xls contains------>Month hrs worked(col1), monthvalue(col2) [ month value is nothing but the hrs worked* rate for each employee]
result.xls----------->In this workbook i need the report for 12 month time selected(say for example if i select sep 09, it shld show me the hr worked and value for each employee from sep 09, to Aug 10)
12 months period how do i do it.
How do I pass the value from one workbook to another workbook cell by cell
Configuration: Windows XP Firefox 3.0.15