I have a sheet with data, c0116 london, on a second sheet, sheet1, I copy some data and create some charts. By using a drop down combo box I want to change cell c1 to another country and change all the data and tables. The highlighted cells on sheet1 all come from the other sheet.
I'm not sure if excel can do this. It sounds to me like something that should be possible but not sure how to approach this. Hope my posting makes sense.
Any help would be gratefully appreciated.