I have two tables with different formats ie... Overall cost and Individual cost.

I would like to know if a toggle button can, at the click change the link from one cell to another cell that are listed on a different worksheet and populate a form.


The "quote" worksheet has a link to the "formula" worksheet currently linked to the Turn Time LOT table and what I would to have is a toggle button that when true, changes the link from the Turn Time LOT table to the Turn Time Unit table.
Mainform table.JPG
Lot charge and Unit charge table.JPG

Thanks in advance for taking time to assist me on this.

Randy