+ Reply to Thread
Results 1 to 3 of 3

Change Sheet Source Name

  1. 03-21-2017, 11:15 PM #1
    azbi
    azbi is offline
    Forum Contributor
    Join Date
    07-06-2013
    Location
    Borneo
    MS-Off Ver
    2016
    Posts
    277

    Change Sheet Source Name

    Dear All

    I have 3 sheets
    1. Summary
    2. DATA 1
    3. DATA 2

    by using Vlookup in Column B and C in summary sheet, how to make a link with sheet data 1 or data 2 if I change E2 by sheet name?
    Attached Files Attached Files
    Last edited by azbi; 03-22-2017 at 12:03 AM.
    Reply With QuoteRegister To Reply
  2. 03-21-2017, 11:59 PM #2
    spitfireblue
    spitfireblue is offline
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: Change Sheet Source Name

    Replace...

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    with...

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Regards,
    Stephen

    If you feel someone has helped you please thank them and click on the star on their post to add reputation.
    Please ensure that you use code tags where relevant, and mark solved threads as solved.
    Most of all please be respectful and understanding of others.
    Reply With QuoteRegister To Reply
  3. 03-22-2017, 12:03 AM #3
    azbi
    azbi is offline
    Forum Contributor
    Join Date
    07-06-2013
    Location
    Borneo
    MS-Off Ver
    2016
    Posts
    277

    Re: Change Sheet Source Name

    Dear spitfireblue

    Thanks, its work
    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. Change source of pivot table dynamically based on sheet name
    By jeroenft in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-03-2016, 11:23 AM
  2. Match data on source and destination sheet and change value
    By Cammandk in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-25-2014, 03:18 PM
  3. Pivot table to refresh and source data to change using visible rows on a filtered sheet
    By papasmurfuo9 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-27-2014, 11:32 AM
  4. Chart Sheet Source data does not change when sheets are copied to new workbook
    By Henk Stander in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-08-2014, 03:01 AM
  5. Links change source when sheet emailed
    By GRAMMY in forum Excel General
    Replies: 1
    Last Post: 10-28-2011, 02:19 AM
  6. Change Source of Link in Protected Sheet
    By Chiku in forum Excel General
    Replies: 0
    Last Post: 12-22-2005, 02:40 PM
  7. [SOLVED] How can I delete source links and change the current sheet accord.
    By Marshanann in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-16-2005, 10:40 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1