Hi All, My son fits out new houses with cupboard shelving. He does all his measuring and comes back with data something like:
0.9 metre lengths x 8 1.1 metre lengths x 5 1.4 metre lengths x 11 1.8 metre lengths x 6 2.2 metre lengths x 12 He can only buy shelving in standard lengths - say 1.8m, 2.4m, 3.0m, 3.6m He spends a lot of time figuring out how many of each standard length to buy to minimise waste and cost. Can XL do this? Any pointers on where to start? Regards - Dave. _________________________________________________________________ It's simple! Sell your car for just $40 at CarPoint.com.au http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworldwide%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801459%2Fpi%5F1004813%2Fai%5F859641&_t=762955845&_r=tig_OCT07&_m=EXT --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
