Posted by John on June 08, 2000 2:01 AM
Is there a way to get a separate sheet to update to the values on a separate page based on the block that is highlighted.
Example if i have a page that has an order number in column a, and the cusomer name in b, and address in columns c,d,e,and f and phone number in g and i want a form on page 2 to update based on clicking the order number or something. I thought about a dropdown menu but there are over 600 and typeing in the number it would be kind of easy to make a mistake because my goal is to eventually hide the list page. And get a form that updates the list page. Anyone that has a similar form/sheet i would be very happy for your help.