Hello All,
I am trying to make a work book that my make my sales job a little easier when I am out in the field.
Page 1 I want to have client information
Page 2 would be a summary page that carries client info over (got this done)
I have a series of 6 and may end up in 10 drop downs that have our products in them
I have a area for notes
Pages 3-37 are equipment specification relating to each drop down box.
Is there a way when a specific item is selected from a drop down box that it will allow me to automatically print the page 2 summary sheet and the specific product specifications selected to hand to the potential client while I am there with them or do I need to select the print pages individually.
I cant help but think there has got to be a way to automate this process
any help would be greatly appreciated
I am trying to make a work book that my make my sales job a little easier when I am out in the field.
Page 1 I want to have client information
Page 2 would be a summary page that carries client info over (got this done)
I have a series of 6 and may end up in 10 drop downs that have our products in them
I have a area for notes
Pages 3-37 are equipment specification relating to each drop down box.
Is there a way when a specific item is selected from a drop down box that it will allow me to automatically print the page 2 summary sheet and the specific product specifications selected to hand to the potential client while I am there with them or do I need to select the print pages individually.
I cant help but think there has got to be a way to automate this process
any help would be greatly appreciated