Hi Everyone,
Please Help!! I'm not even sure this is possible, but this is what I'm trying to do.
On sheet 1 is a grid with a drop down list of 1,2 or 3 for each cell.
On sheet 2 are 3 shapes and a copy of the grid on sheet 1.
What I would like to do is; when a 1 is selected on sheet 1, shape 1 centres over the corresponding cell on sheet 2. and so on for shape 2 and 3.
In addition to this I would like the user to only be able to select a 1,2 or 3 once on sheet 1.
Hope that all makes sense, I've attached a quick draft to help.
If anyone can sort this you truly will be Kings (or Queens) of excel!
Thanks for any help in advance.
E
Bookmarks