retrieve specific info from different 'groups'
I am making a menu workbook. On one sheet I have grouped several different
menus together: breakfast, lunch, dinner; using designators like B1,B2, or L1,L3 etc. Where B1 would have a food item on separate rows ie.eggs, bacon, etc. with caloric and nutritional info in the columns following each item. Of course, the B2,L3,D14... groups would have different items associated with them. On another worksheet in the same workbook, I would like to be able to enter B1 and have all the items in that group, as well as select nutritional data come up. Of course, adding lunch and dinner data as well. Sorry about the long description... BTY, I am currently using Excel '03. Thanx! |
All times are GMT +1. The time now is 05:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com