Is it possible to use vlookup to get a value but when I delete the source, the value remains?

[timhue88]

Hi all,

i currently have a vba macro that generates values for my analysis.


however, i use the same macro sheet for the 100s of accounts that i have to analyze. It would be great if i could use vlookup to get the values on my analysis page. and after delete the content in my macros page. However, i require my analysis page values to remain there.

 

[John Davis]

Hi all,

i currently have a vba macro that generates values for my analysis.


however, i use the same macro sheet for the 100s of accounts that i have to analyze. It would be great if i could use vlookup to get the values on my analysis page. and after delete the content in my macros page. However, i require my analysis page values to remain there.

Sounds like you could incorporate that into your macro.

 

[L33]

If I've understood you correctly, you could try recording the action of copying and pasting Values over the top of the data the vlookups return. That way the results become static values that won't change when the source data is removed.