I use Excel for Order entry and Tracking. Is there a way to set up the
worksheets so that when you enter information on one page, it automatically
fills in certain fields on another page? Sounds confusing but i would like to
know if it can work similar to Lotus.

Thank you.