Forum Discussion
Solved
Setting retrieved data
With the generous help of someone on this forum (thanks again!), I was able to retrieve some data that had been messed up on my Excel sheet. We used a VLOOKUP function to sync two columns of data tha...
Here's the way I said it in the file
And here's where you find it in the Edit menu:
And once you select Paste Special you'll see this next choice: Select "Values"
Just to be completely clear: you first select the VLOOKUP cells and do Edit...Copy, then go to the place where the actual values need to be pasted and select Paste Special, etc.
Simple Copy and Paste will produce exactly the problem you're experiencing. It's Copy...Paste Special that you want.
