Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Excel with VBA

  Asked By: Gowri    Date: Dec 05    Category: MS Office    Views: 1203
  

I have 12 workbooks,every workbook has 12 sheets,and every sheet has different type of road vehicle survey data in same formate and these data has time interval ,for ex the data is,

Time car T.W auto minibus bus 3WGoods LCV HCV MAV cyc CR other
7-7.15 58 30 15 2 6 2 1 2 0 0 2 0
7.15-7.30
7.30-7.45
7.45-8.00 like upto 24 hours.

car,T.W,Auto,Minibus,Bus comes under - Passenger Vehicles
3WGoods,LCV,HCV, MAV comes under - Goods Vehicles
Cycle,Cycle Rickshaw,Others comes under - Slow Moving Vehicles

Then i need Total Passenger Vehicles,Total Goods Vehicle,Total Slow Moving Vehicles ,Total Vehicles ,Total PCU Vehicles for every one hour(like 7-8,8-9...6-7)using Visual Basic Application .How to i calculate every sheet?Because i am new for VBA .
I really hope that you guys can help me with some code and/or point me into the right direction.
Thanks in advance guys!

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Excel with VBA Or get search suggestion and latest updates.




Tagged: