| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
