+ Reply to Thread
Results 1 to 4 of 4

VLOOKUP - Copy Results.

Hybrid View

  1. #1
    Registered User
    Join Date
    11-06-2006
    Posts
    27

    Question VLOOKUP - Copy Results.

    I have a spreadsheet with 3 worksheets. The 1st worksheet has a column which has a combination VLOOKUP functions - two different versions. One version pulls data from the 2nd worksheet while the other pulls data from the 3rd.

    All these spreadsheets are comnfusing to the person who is to read the report. I want to get rid of the two extraneous worksheets and have just the 1st one. How can I retain the results of the function(s) and get rid of the other worksheets? I'd be will to create a new spreadsheet altogether as long is I don't have to link it to the original to retain the data.

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by Keeper4826
    I have a spreadsheet with 3 worksheets. The 1st worksheet has a column which has a combination VLOOKUP functions - two different versions. One version pulls data from the 2nd worksheet while the other pulls data from the 3rd.

    All these spreadsheets are comnfusing to the person who is to read the report. I want to get rid of the two extraneous worksheets and have just the 1st one. How can I retain the results of the function(s) and get rid of the other worksheets? I'd be will to create a new spreadsheet altogether as long is I don't have to link it to the original to retain the data.
    You can Copy the data, and Paste Special Values to a new worksheet.

    this removes all formula and retains the data

    hth
    ---
    Si fractum non sit, noli id reficere.

  3. #3
    Registered User
    Join Date
    11-06-2006
    Posts
    27

    Thumbs up Problem Solved.

    Too easy! Thanks.

  4. #4
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by Keeper4826
    Too easy! Thanks.
    good to see, and thanks for the response
    ---

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1