these are the instructions my workers will see when they open the program Sheet 1 - titled 'Instructions'
indicate by placing an 'X' in the box which fuel type you are using
Petrol
Diesel
................................................................................................................................................
this is what I want to happen, once a selection is made.
If cell f5 is selected, automatically go to sheet titled 'petrol' cell A2
If cell f7 is selected, automatically go to sheet titled 'Diesel' cell A2
I do not want workers to be able to manually open the wrong page.
I've tried a few ideas, but with no success. Any help would be appreciated.
Bookmarks