Printing VLOOKUP Results Into Text w/o Formula

[skyxliner]

So I have various Vlookups for a sales log entry I'm trying to do. Only problem is I want it to after it does the vlookup and shows the value, I want it to convert permanently to text and remove the vlookup formula.

Is this best accomplish with a macro? or is there an option to do this best if possible?

for example

i'm using vlookup to display current quantity values in a sales entry log. But I want it to record a history of lookups at the current time saved. so that they dont' all change as the quantity changes.

[davesexcel]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[skyxliner]

Initially what I wanted was to use vlookup to display the current remaining inventory for employees to reference on the spot.

After I had that working, I realized on a sales log, as the quantity changes, it changes it for all previous sales entries as well.

I would like to set it up where once vlookup performs the calculation, it'll print the results in static form instead of dynamic where it updates again the next time.

[Ang12345]

May be easiest to do a copy and paiste special values so you get the values that are in the cells, that will remove the formulas.

[skyxliner]

your post made me do some searching,

http://www.mrexcel.com/forum/showthread.php?t=75379

this post is similar to what i want to do but his macro coding was alittle too complicated for me to understand.

Is there a way I can automate the paste special? perhaps use MACRO and record the paste special over its self?

but how could I get it to go down the entire column automatically?