I have to calculate the running hours every day and store them in an excel sheet. Now I calculate the total running hours in one table and manually enter the result in the data sheet. I want that to happen automatically. In the attachment, I enter the values in sheet 2 and the values must be transferred to the relevant row in sheet 1. The condition will be date in each row should be compared with that in c3 sheet 2. And I should not loose the previous day data.
Use this code in your file - Copy it to a blank module -This code will take care of any number of rows in each section A to F. Also, any number of columns even after F in Sheet2 will be included. Just ensure that the corresponding additions - G, H, I, etc are added manually in Sheet1.
Please Login or Register to view this content.
Last edited by arlu1201; 01-18-2012 at 10:56 AM.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks