Hi
I got a large excel data sheet in which the Month and year is given in one column and date in next coloumn. Unfortunately the date is in number format ( sample file is attached) and month is given in the first date row only. Anybody can help me to find the total incidents in the coloumn D and put in next coulmn automatically?
Hi, Try the attached.
NB:- There is a slight fiddle on this code as it Places a Marker (The word "Last") at the end of column "B", to enable the code to run over the entire range.
Regards Mick
You can do it with formulas - which row do you want the total in, or do you want running totals?
Remember what the dormouse said
Feed your head
Thank You Very much MichG,Originally Posted by MickG
Your Help is really appreciated..
Its working fine..
You are going to save my hours of tedious work.
Next I want to sort out the result to next sheet. That i will try myself.
Thanks Again......
If the table were set up correctly, i.e. no empty cells in the dates column then you wouldn't need VBa, a pivotTable would be much better
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I tried it using Pivot Table. But no success. Could you help me on how to do it?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks