+ Reply to Thread
Results 1 to 4 of 4

Extracting values

  1. #1
    Registered User
    Join Date
    04-27-2020
    Location
    Istanbul
    MS-Off Ver
    2016
    Posts
    41

    Extracting values

    Hi, is there a way to extract a table with values that comes from references just as values? I have a table, and all cells show referenced values from other sheets. For instance, G5 is ='Sheet 1'!$U$28, which is 49. Is there a way to copy a table full of references like this just as values and paste it to a completely new Excel file without involving the calculations, formulas and references but just the results.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,366

    Re: Extracting values

    Have you tried using Paste Special | Values ?
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    04-27-2020
    Location
    Istanbul
    MS-Off Ver
    2016
    Posts
    41

    Re: Extracting values

    Welp, I didn't know it worked that way, thanks a lot..

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,366

    Re: Extracting values

    You're welcome. Thanks for the rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extracting Values to new tab
    By mediator in forum Excel General
    Replies: 8
    Last Post: 09-25-2017, 05:32 AM
  2. [SOLVED] Extracting Values
    By yuenk in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-26-2017, 11:55 AM
  3. Extracting values from a PDF
    By FDibbins in forum Excel General
    Replies: 10
    Last Post: 09-25-2013, 02:22 AM
  4. [SOLVED] Need help with extracting values
    By zarealshook in forum Excel General
    Replies: 3
    Last Post: 12-12-2012, 05:56 AM
  5. Extracting values
    By john27 in forum Excel General
    Replies: 3
    Last Post: 09-24-2012, 05:49 AM
  6. Extracting values from A1, A11, A21
    By allstarbiotech in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-29-2011, 08:53 PM
  7. Extracting values (?)
    By beedee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-04-2007, 11:03 AM

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