+ Reply to Thread
Results 1 to 13 of 13

Copy/Paste *values* from equation data on a separate sheet in the same workbook

Hybrid View

  1. #1
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Copy/Paste *values* from equation data on a separate sheet in the same workbook

    I think you need to explain more... because what's wrong with:

    =Sheet2!B20
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  2. #2
    Registered User
    Join Date
    11-18-2020
    Location
    Nicaragua
    MS-Off Ver
    EXCEL V16.39
    Posts
    21

    Re: Copy/Paste *values* from equation data on a separate sheet in the same workbook

    Hi Glenn,

    I originally used this formula in my worksheet, but a finder prompt keeps popping up saying "Cannot locate file titled '2'". Does the formula need to include my specific sheet name perhaps?
    I figured it would be as simple as you suggest but it doesn't seem to work on my end

    Thank you

+ 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. VBA Copy, move, unlock active sheet and paste as values to a new workbook
    By archvanarl in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-09-2020, 03:01 AM
  2. [SOLVED] Copy & Paste Values To Separate Workbook
    By ClwnMan76 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-18-2019, 03:09 PM
  3. [SOLVED] Copy & Paste Cell Values based on conditions to separate sheets from primary sheet
    By spyac in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-05-2018, 08:04 PM
  4. [SOLVED] Copy cell values from one sheet and paste it in another sheet of the same workbook
    By Tauheed Ahmed in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-13-2016, 08:51 AM
  5. Copy values from sheets in workbook and paste in one sheet in the same workbook
    By RinorM in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2015, 04:14 AM
  6. Copy Values to separate sheet, locate value in list and paste 6 cells to the left
    By drknot in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2014, 10:16 AM
  7. Replies: 6
    Last Post: 03-26-2014, 11:40 PM

Tags for this Thread

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