View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave McD Dave McD is offline
external usenet poster
 
Posts: 2
Default Splitting a file with lookup functions into smaller parts

I have a large file I want to split into several smaller pages. It has the
VLOOKUP function in it that refers to specific pages within the worksheet.
What is the fastest way to save one page of the worksheet without losing all
the values when I delete the pages that the VLOOKUP function refers to?