Replies

Thanks Hans,

Will try both of your suggestions and see which one works best.

Thanks Steve,

I really appreciate your suggestion. The spreadsheet we are using currently has VB in to Read_tables, but the only person in our area who knows VB is the manager who created the initial formula. Several of us would like a backup method of doing the same thing in Excel just in case the manager leaves and we have no one to support the VB code. Several people can see many uses in other places for this type of formula and your solution saving memory and calculation time will come in very handy. Thanks.

Capri

Thanks Hans,

That solved the problem. I had minor problems converting it to my own spreadsheet, but finally managed to get it right. I’ve been trying to replace some VB code that a manager gave me as trying to get any support for the VB is difficult. This is a very handy formula and I can see many uses for it.

Capri

Thanks for the help.

Guess I wasn’t thinking straight, thanks for pointing out my error. I’ll keep the formula just incase the people who want the report insist on having a percentage.

here’s the other document

Perhaps one of these documents may help.

You need to press the + key after the ALT and before the number.

Thanks, will give it a try when I get home.

We run ZoneAlarm set to not allow anything through without permission.

it’s not quite like vanilla pudding. You usually find it in the baking section at the supermarket at least you can in Canada and Australia. Haven’t looked in any other countries. I would presume it is used to make custard (which I’ve never made). Only ever used it for nanaimo bars. You might not get the right consistency if you substitute, but likely vanilla pudding mix would be the best thing to try.

it’s not quite like vanilla pudding. You usually find it in the baking section at the supermarket at least you can in Canada and Australia. Haven’t looked in any other countries. I would presume it is used to make custard (which I’ve never made). Only ever used it for nanaimo bars. You might not get the right consistency if you substitute, but likely vanilla pudding mix would be the best thing to try.

Bottom Layer
Butter …….

Bottom Layer
Butter …….

Marie biscuits just don’t do it. I’m living in Oz now..and whenever I go home load up on Graham crackers…wish David Jones would carry them in their food shops…my favourite recipe..nanaimo squares needs them…recently made them for a group of ex-pats and their Aussie spouses..some had never tried them before and all agreed..not the same using anything else

Marie biscuits just don’t do it. I’m living in Oz now..and whenever I go home load up on Graham crackers…wish David Jones would carry them in their food shops…my favourite recipe..nanaimo squares needs them…recently made them for a group of ex-pats and their Aussie spouses..some had never tried them before and all agreed..not the same using anything else

Bread works, but every now and then you need to replace it. In some specialty cooking stores you can buy a small round disk that you can put in the brown sugar to keep it soft. I have one and it works fine. The disk is usually a terra cotta colour…not sure why it works..but it does.

Bread works, but every now and then you need to replace it. In some specialty cooking stores you can buy a small round disk that you can put in the brown sugar to keep it soft. I have one and it works fine. The disk is usually a terra cotta colour…not sure why it works..but it does.