After VLOOKUP!
 

I've done a VLOOKUP function to automatically enter postcodes and it works
fine. However, now I want to move the data off the spreadsheet without the
vlookup functions. I just want the data, without the functions. Anyone know
how to make the data pure data again? Without any ties to a lookup sheet?

Thanks!


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200510/1

After VLOOKUP!
 

You will need to use Edit... Paste Special featu
Select range of postcodes you need
Press Ctrl-C OR Edit...Copy
Go elsewhe different worksheet or workbook
Do Edit... Paste Special... choose Values option and OK
HTH
Paul
I've done a VLOOKUP function to automatically enter postcodes and it works
fine. However, now I want to move the data off the spreadsheet without the
vlookup functions. I just want the data, without the functions. Anyone
know
how to make the data pure data again? Without any ties to a lookup sheet?

Thanks!


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200510/1

After VLOOKUP!
 

Select the data
Cop
Menu EditPastespecial
Choose Values
OK


--
HTH

Bob Phillips

"eternal_cat via OfficeKB.com" <u14645@uwe wrote in message
news:55a75fad929bf@uwe...
I've done a VLOOKUP function to automatically enter postcodes and it works
fine. However, now I want to move the data off the spreadsheet without the
vlookup functions. I just want the data, without the functions. Anyone
know
how to make the data pure data again? Without any ties to a lookup sheet?

Thanks!


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200510/1

After VLOOKUP!
 

Thanks Paul, worked beautifully :).


count wrote:
You will need to use Edit... Paste Special featu
Select range of postcodes you need
Press Ctrl-C OR Edit...Copy
Go elsewhe different worksheet or workbook
Do Edit... Paste Special... choose Values option and OK
HTH
Paul
I've done a VLOOKUP function to automatically enter postcodes and it works
fine. However, now I want to move the data off the spreadsheet without the
[quoted text clipped - 3 lines]

Thanks!


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200510/1

After VLOOKUP!
 

Select (whole columns if you don't have data below you need to leave
behind).
Copy,
Select new location
Edit, Paste Special - Values

Record your keystrokes to turn into a Macro


Hint to carry over required formats do two paste actions. First, just Paste.
After that, Paste Special - Values without de-selecting the paste location.

Steve

"eternal_cat via OfficeKB.com" <u14645@uwe wrote in message
news:55a75fad929bf@uwe...
I've done a VLOOKUP function to automatically enter postcodes and it works
fine. However, now I want to move the data off the spreadsheet without the
vlookup functions. I just want the data, without the functions. Anyone
know
how to make the data pure data again? Without any ties to a lookup sheet?

Thanks!


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200510/1