j3andc
Board Regular
- Joined
- Mar 4, 2002
- Messages
- 172
I have a spreadsheet that I am using for my checkbook. One page has the checks in it and it looks at the second sheet that is populated with the cleared checks.
I am using vlookup, sumif and sumproduct. Nothing fancy, but the data is 500 plus lines and it is taking a while to calculate (Excel 2000, by the way).
Is there a way to reduce the amount of calculation time?
Thanks
Jim
I am using vlookup, sumif and sumproduct. Nothing fancy, but the data is 500 plus lines and it is taking a while to calculate (Excel 2000, by the way).
Is there a way to reduce the amount of calculation time?
Thanks
Jim