Not sure if this would work for you but I will take a stab at it. On the bottom of Excel you have a few tabs....default is sheet1, sheet2, etc. You can customize the tabs to read bedroom 1, bedroom 2, etc. Then make one sheet summary and reference the cells from the other sheets. Hope this helps.
http://www.mvps.org/links.html#Excel Check here if you need some help with excel. Great stuff for anything M$ in fact.
[This message has been edited by kinetic (edited 01-17-2005).]
