I have an excel document with various names in different cells. What I want to do is put a number next to a name i.e Daz in A1 and 7 in A2 and if that name appears again somewhere else in the spreadsheet i.e Daz in F7 I want 7 to be entered automatically in G7 without me having to type it! I hope this can be understood!!
define the range that contains the original names and numbers, it would be possible using VBA. It would be a lot easier, I think, if the numbers were next to the names, rather than underneath. You have "Daz" in A1 and "7" in A2, rather than B1... is that what you meant?
Anyway, supposing you had names entered in the range A1:A50, with corresponding numbers in B1:B50, and you gave the range A1:B50 a name, I think it could be done.
It would take me a while to think about it, and I'm sure others could do it quicker, but there may be repercussions on other cell entries; suppose you entered the name "Gaz" in cell F10... what you have asked for would mean that "7" would be automatically entered in cell G10, regardless of another entry being already there... is that what you want?
Anyway... I'll have a think and a play... but I bet someone else gets there first!