I have several worksheets in one file. Each worksheet has sales figures in it which relates back to the combo box in the first sheet which is the home page.
In the home page i have a drop down combo box with over 20 sales reps names in it. These names represent individual locations and states (e.g. NNO, NSO NWE, NCN) (eg NNO -NSW North) and so on. (the information in one worksheet represents one sales rep)
Each sheet shows sales figures for each sales rep for 2003, 2004, 2005 and 2006.
When you select a sales rep from the combo box on the home page it should automatically retrieve the figures from the correlating worksheet and paste it into the relating cells on the home page
i have acheived this using the IF formula however it will only allow me to do it for 6 sales reps and not 27.
The formula I used is shown below;
Hope you can help!