I am creating a new set of forms. On the first sheet I have the master data sheet which you fill in and all info is then auto filled in to multiple forms each on additional sheets. On Data page, in the first box, I have a drop box to select 1 of 6 options. when option is selected, this data is filled in a cell on sheet 2. What I am unable to now work out is how depending on the selection of 1-6 on the drop down box, additionally i would like each selection to be linked to a different statement which will then be posted in a cell on sheet 3.
I have spent weeks trying to work this out. Any help would be much appreciated.