Hello all, I have a spreadsheet that Dale and others helped with, and I'm having to make changes and fix problems and Dale's no longer really "available". So hopefully one of you will be able to assist me.
I have a spreadsheet to which I export raw data (to the 'DATA' sheet). This information includes the name, address, etc, juror hours, juror payment due, juror mileage, juror mileage due.
I then have a macro that should clear any existing data on the 'Voucher Report' page, check that juror payment due + juror mileage due = 0 and if it does DELETE THAT ROW SO NO PAYMENT IS PROCESSED AND THE PERSON DOESN'T SHOW UP ON THE VOUCHER PAGE. As I have found previously, deleting a row can cause problems!
I thought I was making progress on the checking for zero value, but now, early code is failing! I would appreciate some guidance and help. I can email the spreadsheet if anyone can take a look at it for me!
Thanks!
Leslie
landrews@metrocourt.state.nm.us
There are 10 types of people in the world -
those who understand binary
and
those who don't!
I have a spreadsheet to which I export raw data (to the 'DATA' sheet). This information includes the name, address, etc, juror hours, juror payment due, juror mileage, juror mileage due.
I then have a macro that should clear any existing data on the 'Voucher Report' page, check that juror payment due + juror mileage due = 0 and if it does DELETE THAT ROW SO NO PAYMENT IS PROCESSED AND THE PERSON DOESN'T SHOW UP ON THE VOUCHER PAGE. As I have found previously, deleting a row can cause problems!
I thought I was making progress on the checking for zero value, but now, early code is failing! I would appreciate some guidance and help. I can email the spreadsheet if anyone can take a look at it for me!
Thanks!
Leslie
landrews@metrocourt.state.nm.us
There are 10 types of people in the world -
those who understand binary
and
those who don't!