Macro to update a cell

[monkeyharris]

I know this sounds easy but i'm having a blank.
I have a drop down list in cell V61 and a formula that looks up that cell in V57. I need a macro to click in V57 and press enter every time the drop down in V61 is changed.

Mark Postcode Map.xlsm
	N	O	P	Q	R	S	T	U	V	W	X
55
56
57							Enter Postcode		CT
58
59
60
61	Enter First Half of Delivery Postcode								CT50
62
General Tariff

Cell Formulas
Range	Formula
V57	V57	=VLOOKUP(V61,'Postcode Districts'!A2:B2993,2)

Cells with Data Validation
Cell	Allow	Criteria
V61:W61	List	=$AI$1:$AI$2992

 

[Engberg]

What are you trying to accomplish by clicking in V57 and pressing enter?

 

[Fluff]

Duplicate to: Formula looking at Drop-Down list doesn't update my Shape

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.