Delete sheet 2 with VLookup references and keeping the data in sheet 1

**MaartenRo** · 03-02-2021, 02:36 AM

Hi,

I have sheet 1 with a filtered range with 2 columns containing Vlookup functions to a range in sheet 2 in the workbook. I would like to delete the reference sheet 2 but the problem is that than the values are not shown anymore in the sheet 1. Copying and pasting the values doesn't work i guess because of the filter. How can i solve this?

**Eastw00d** · 03-02-2021, 03:03 AM

Hi Maarten, what if you select and copy the table in sheet1 and paste this somewhere, like

Please Login or Register  to view this content.

Then you can delete your second sheet
Cheers
Erwin

**MaartenRo** · 03-19-2021, 06:17 AM

thank you very much

Delete sheet 2 with VLookup references and keeping the data in sheet 1

LinkBack

Thread Tools

Rate This Thread

Display

Delete sheet 2 with VLookup references and keeping the data in sheet 1

Re: Delete sheet 2 with VLookup references and keeping the data in sheet 1

Re: Delete sheet 2 with VLookup references and keeping the data in sheet 1

Thread Information

Users Browsing this Thread

Similar Threads

Change all references from Data sheet:Row C to Data sheet:Row X"

copy data from one sheet to another keeping data from original sheet

Delete duplicate rows from comparing sheet 1 with Sheet 2 and export new data in sheet 3

Vlookup change all sheet references

VLOOKUP table on one sheet that references every sheet in workbook

multiple sheet data in 1 sheet then delete every sheet except the masterlist.

Move Graphs to new excel file keeping sheet and cell references only

Bookmarks

Bookmarks

Posting Permissions