+ Reply to Thread
Results 1 to 5 of 5

toggle button to switch data between sheets and back

  1. #1
    Registered User
    Join Date
    09-05-2016
    Location
    cairo
    MS-Off Ver
    Office 2016
    Posts
    39

    toggle button to switch data between sheets and back

    Hello,

    in the attached file you will find two sheets. sheet1 contains small table representing names of current team members we have right now in 3 countries. and in sheet2 we have the same table but with names of new team members.

    how is it possible to add a toggle or an action button on sheet1, that when clicked on it will take the names from sheet2 into sheet1 and then switch it back by clicking on a second or same button.

    so for example: button1: will take the names from sheet2 and replace the names on sheet1
    button2: will switch back to original names on sheet

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: toggle button to switch data between sheets and back

    If I understand correctly, the second button is basically like an "undo" for the changes made to sheet1 by the first button?

    If I click button1 twice, should it still be able to go back to the original? before any buttons were clicked?

    Is there more data on sheets 1 and 2? or is the list of names all that is there?
    Last edited by Arkadi; 03-03-2017 at 11:05 AM.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: toggle button to switch data between sheets and back

    Give this file a try:
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-05-2016
    Location
    cairo
    MS-Off Ver
    Office 2016
    Posts
    39

    Re: toggle button to switch data between sheets and back

    Thank you for you help. it worked really well

  5. #5
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: toggle button to switch data between sheets and back

    Thanks for the feedback and 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. Replies: 1
    Last Post: 11-26-2014, 04:28 AM
  2. Toggle Button that will switch the cell data between gallons and barrels
    By Kadrak in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-23-2014, 05:42 PM
  3. Replies: 1
    Last Post: 02-13-2014, 10:55 PM
  4. [SOLVED] Userfrom next/back button to toggle
    By Dev123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-26-2012, 07:48 AM
  5. How to HIDE/UNHIDE Specific Sheets Using a TOGGLE Button?
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-16-2011, 02:58 AM
  6. Linking a cell to a toggle switch
    By Brisbane Rob in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-28-2005, 07:41 PM
  7. [SOLVED] Toggle on/off switch for x-y graph
    By Brad in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-18-2005, 11:05 PM

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