+ Reply to Thread
Results 1 to 6 of 6

Show Value From Hidden Sheet

  1. 05-24-2017, 09:21 AM #1
    putritersenyum
    putritersenyum is offline
    Forum Contributor
    Join Date
    03-04-2015
    Location
    Jakarta
    MS-Off Ver
    15
    Posts
    154

    Exclamation Show Value From Hidden Sheet

    I have sheet1 sets hidden, but I want to get data from sheet1 range A1:A10 in sheet2 range B1:B10.
    Please, help me to get data from hidden sheet.
    Reply With QuoteRegister To Reply
  2. 05-24-2017, 09:35 AM #2
    CK76
    CK76 is offline
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,913

    Re: Show Value From Hidden Sheet

    In B1:
    =Sheet1!A1

    Copy down. (Assuming sheet1 is actually named "Sheet1").
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein
    Reply With QuoteRegister To Reply
  3. 05-24-2017, 09:47 AM #3
    putritersenyum
    putritersenyum is offline
    Forum Contributor
    Join Date
    03-04-2015
    Location
    Jakarta
    MS-Off Ver
    15
    Posts
    154

    Re: Show Value From Hidden Sheet

    CK76, it's only work for visible Sheets. But the Sheet1 is hidden.
    Reply With QuoteRegister To Reply
  4. 05-24-2017, 09:56 AM #4
    TMS
    TMS is offline
    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,754

    Re: Show Value From Hidden Sheet

    Have you tried it? The fact that Sheet1 is hidden shouldn't prevent a formula referring to cells on it.
    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

    Reply With QuoteRegister To Reply
  5. 05-24-2017, 10:07 AM #5
    putritersenyum
    putritersenyum is offline
    Forum Contributor
    Join Date
    03-04-2015
    Location
    Jakarta
    MS-Off Ver
    15
    Posts
    154

    Re: Show Value From Hidden Sheet

    TMS & CK76, your are right. I have tried and it works. the problem is from the formula on Sheet1. thank you.
    Reply With QuoteRegister To Reply
  6. 05-24-2017, 10:14 AM #6
    TMS
    TMS is offline
    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,754

    Re: Show Value From Hidden Sheet

    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hidden sheet won't show up
    By Rob K in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-10-2015, 08:53 AM
  2. Macro to show worksheets based on a a hidden sheet, that lists the sheets that should show
    By preetypj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2014, 06:03 AM
  3. Macro to show the copy of a hidden sheet
    By gaftalik in forum Excel General
    Replies: 2
    Last Post: 01-18-2011, 09:03 AM
  4. Create a macro to show a hidden sheet.
    By yanikeke in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-19-2010, 07:23 PM
  5. Create macro to show hidden sheet
    By ncaravela in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-30-2010, 11:50 AM
  6. VBA Function Vlookup data from Hidden sheet in hidden workbook
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-16-2008, 11:22 PM
  7. [SOLVED] I need my Hidden Rows to stay hidden when I print the sheet.
    By Rosaliewoo in forum Excel General
    Replies: 2
    Last Post: 07-20-2006, 02:51 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1