Copy VLookup value from 1 cell to another once for whole column

Hello,

I'm a total newcomer to Excel functions, macros, and VB code.

I have created a spreadsheet with a vlookup formula (=VLOOKUP(C2, CustomerName:CustomerCode,2,FALSE)) in column D and I want Excel to copy the returned value from that cell to cell E only once (no updating if that vlookup value changes) perhaps when I enter cell E would be good. Is this possible?

Thanks for you any help you can provide.

Stacy

1. Open your VBA editor by pressing Alt+F11
2. In the VBA editor, on the left side, is the project explorer
3. Find your workbook, then double click on the sheet object that you want the code to run on (Sheet1 or whichever sheet)
4. Paste the code shown below into the white space to the right of the project explorer.

The code will run automatically any time you double click any cell in Column E.

Please Login or Register  to view this content.

Thanks walruseggman. That worked perfectly!