Quote Originally Posted by IZAKK View Post
In my example the cell A2 in sheet five would have the value of 3 because 3 would be the last non-blank and greater than zero entry of the sheets (sheets 1 thru 4). I'm trying to keep tract of an account by month. Each month has it's own sheet (Jan thru Dec). The value each month could go up or down so I want the latest months value in my results sheet. In my example sheet five would be my results sheet. I going to try to attach an example log to this if I can. I hope that made more sense. Thanks for the help.
Just trying to get this back up top to hopefully get some help. Anybody have any ideas?