Prev: Copy data using macro (with worksheet protect)
Next: Finding File Extension from Full Filename (VBA) (2007)
From: Angel H on 2 Jun 2010 14:47
HI,
i am looking for a way to sum columns of data, until they hit a specific
number, then after that point quit summing them and remove the data not
needed.

A B C D E F G H
ID Ja Fe Ma Ap Ma Ju Tot
23 4 8 6 9 1 28

so basically i want it to sum column B and C, check to see if its totally
24, if not continuing summing until you hit 24. Then delete the values over
24.

thoughts?
thanks for any ideas!
--
Angel
 | 
Pages: 1
Prev: Copy data using macro (with worksheet protect)
Next: Finding File Extension from Full Filename (VBA) (2007)