Hello Don,
This macro does not work either, The worksheet encountered problem and had
to shut down prematurely when I run it.
I run the Macro again using the recovered file, the error message code now
is 1004.
I have enabled all the macro to run in the system, the error message still
persist.
The other screen mesages are sent to you at your e-mail address for study.
Thank you anyway at least I have just began to leran how to record and run a
macro program today.
Kind Regards
Low
--
A36B58K641
"Don Guillett" wrote:
This should do it.
Sub SumByCategory()
lr = Cells(Rows.Count, "a").End(xlUp).Row + 1
mr = 2
Do Until Cells(mr, 2) = 0
mname = Cells(mr, 1)
nr = Columns(1).Find(mname, after:=Cells(lr, 1), _
searchdirection:=xlPrevious).Row
Cells(nr, 3) = Cells(nr, 2) - Cells(mr, 2)
mr = nr + 1
Loop
End Sub
--
Don Guillett
SalesAid Software
"Mr. Low" wrote in message
...
Dear Sir,
I have the following worksheet data:
A B C D
Vehicle Speedometer Mileage
1 BBN2361 9650
2 BBN2361 10600
3 BBN2631 12800 xxxxx (+B3-B1)
4 BSK1400 8500
5 BSK1400 9320
6 BSK1400 10250 xxxxx (+B6-B4)
7 BGA2367 12500
8 BGA2367 14260
9 BGA2367 16850 xxxxx (+B9-B7)
The mileage is calculated by getting the difference between the last and
the
first speedometer reading of the same verhicle.
May I know if there is any formula that I can input at C1 and copy down to
get straight annswer at C3, C6 and C9 ? Other cells in column C is left
blank.
Thanks
Low
--
A36B58K641