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,

I am only loosely grasping what you are trying to do, but since you mentioned looking up things via VLOOKUP then use something like =VLOOKUP(somevalue, somelookup range, Offset, False) where Offset is determined by your toggle it could be 1 or 8.

Only suggestion. Add Two more columns In Sheet1 to get required data with vlookup functions.
If not upload file with lookup functions.

Originally Posted by dflak

I am only loosely grasping what you are trying to do, but since you mentioned looking up things via VLOOKUP then use something like =VLOOKUP(somevalue, somelookup range, Offset, False) where Offset is determined by your toggle it could be 1 or 8.

Trying to make it so the Vlookups on Sheet 1 change their column lookup with the click of a button. Not sure if that is even possible. I guess I can physically record a macro and do it that way if I must since it will always be the same two columns switching back and forth.

You can use radio buttons or a checkbox. In the sample file I used radio buttons.
Named ranges created:
January ='ws 2- -Inventory Report'!$A$3:$A$169
OnHand ='ws 2- -Inventory Report'!$E$3:$E$169
Option ='ws1 - Forecasting'!$D$1
TotalInv ='ws 2- -Inventory Report'!$H$3:$H$169
TrueSales ='ws 2- -Inventory Report'!$I$3:$I$169

---

typical formula in cells (e.g. A2):

Please Login or Register  to view this content.