Results 1 to 7 of 7

Single Button Toggle Switch To Switch Between Columns

Threaded View

  1. #1
    Registered User
    Join Date
    06-15-2021
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    34

    Single Button Toggle Switch To Switch Between Columns

    Currently looking to make a toggle button to show our Inventory On Hand which is the inventory we currently have minus our Open Orders (This is represented as On Hand in Column E on Worksheet 2.) and True Sales. (This is represented as True Sales in Worksheet 2 Column I.) [/I] These two columns are linked to Worksheet 1 Column A (Inventory On Hand) and Column B [I](True Sales) via a Vlookup (I have not provided our item codes represented in the vlookup but they will technically be in column A.. I want to be able to press a button and it changes Column A on Worksheet 1 to Total inventory (Column H on worksheet 2) and Column B on Worksheet 1 to January Column A on worksheet 2). Then make it so clicking it again changes it back.

    The purpose of this will it can change all of our projections based on what we sell and have sold, so at the end of the month if we haven't shipped out all of our open orders we can see what were looking like for next month.

    If I am being 100% honest I do not mind trying to work it out myself I just need a little help and a push in the right direction on how to swap between different formulas in a column.

    If more information is needed feel free to ask me.

    Thank you,
    Attached Files Attached Files
    Last edited by Zaerick; 01-27-2022 at 10:35 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating a Toggle Switch
    By zyzzyva57 in forum Excel General
    Replies: 6
    Last Post: 12-08-2018, 04:18 PM
  2. [SOLVED] on/ff toggle switch
    By Kausch in forum Excel General
    Replies: 4
    Last Post: 03-23-2018, 12:28 PM
  3. [SOLVED] toggle button to switch data between sheets and back
    By smsmworld in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-07-2017, 09:15 AM
  4. 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
  5. 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
  6. [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
  7. [SOLVED] how to quickly toggle or switch to next worksheet
    By Kwong Yau Leung in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-09-2005, 06:06 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