I used Vlookup to take information from worksheet 5 and display it on worksheet 1. What can I do so that I can delete worksheet 5 but still have its information display on worksheet 1. As it stands now, if I delete worksheet 5, The information on worksheet 1 will disappear because vlookup is getting the data from worksheet 5.
2007-03-01 04:35:27 · 4 answers · asked by aDWsd 1 in Computers & Internet ➔ Software
If you just want to retain the data on worksheet one just copy and paste it using the "paste special" option from the edit drop down menu and select the values option. This will past the information but not the formulas used to get it. If, however, you want to retain the ability to look up the data you can copy the information on sheet 5 and paste it into a remote section of worksheet one.
2007-03-01 10:17:53 · answer #1 · answered by cjdtucson 2 · 0⤊ 0⤋
If you did the vlookup, and are done with it, you can do Copy/Paste Values, and you'll be ok to delete the Worksheet5. Just remember that if you do that, the info is frozen and won't ever update.
2007-03-01 21:08:07 · answer #2 · answered by Jason 3 · 0⤊ 0⤋
I think copy worksheet 1 then delete 5 then paiste.
If not mabe copy then open new then paiste then delete if you know what I mean.
2007-03-01 12:39:23 · answer #3 · answered by Dude 3 · 0⤊ 0⤋
Do right click, copy, and then when you get to the cell you want to paste - do right click "paste special" and then click "value"
let me know.
2007-03-01 12:38:57 · answer #4 · answered by Robby's Girl 2 · 1⤊ 0⤋