Search : in
By :

Calculate data & travrse thru diff Sheet/Wrbk

region4t, on Nov 2, 2009 4:21:26 pm GMT 
 Report this message to moderators

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

Best answers for « Calculate data & travrse thru diff Sheet/Wrbk » in :
How to compare 2 excel sheet and combine uniq data? ShowHow to compare 2 excel sheet and combine uniq data? Issue Solution Note Issue I have 2 excel sheets , A and B. There are redundant data in both sheets as well as uniq. All i want is to combine both with no redundant records. (A+B...
Log in remotely with SSH (Linux) ShowLog in remotely with SSH (Linux) Issue Solution Using SSH through a proxy: Issue Log in remotely with SSH under Linux. Solution The commands below are relevant only if you have an existing account on the PC you want to connect and...
Backup Outlook 2003 data ShowBackup Outlook 2003 data All Outlook 2003 data ( Emails, Agenda, Contacts, Tasks...) are in one file with .pst extension The file is in the following default folder: C:\Documents and Settings\Login\Local Settings\Application...
Download All-In-One Calculator ShowAll-In-One Calculator is a scientific calculator with many features. It allows you to modify the data when calculating (add, delete or rectify values). It includes the following functions: a currency conversion, percentage calculation, formula...
Download The Love Calculator ShowLove is a big word, then all means are good to find it. The name of each can say about it on compatibility between two persons a lot. The Love Calculator is a program which counting affinity between two individuals. It is not a precise science,...
Data transmission - Cabling ShowCabling types Several physical data-transmission media are available to connect together the various devices on a network. One possibility is to use cables. There are many types of cables, but the most common are: Coaxial cable Double twisted...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Linux - The shell ShowIntroduction to the shell The command interpreter is the interface between the user and the operating system, hence the name "shell". The shell therefore acts as an intermediary between the operating system and the user thanks to command lines...