What code could I use for this one?

Saxus

New Member
Joined
Nov 7, 2017
Messages
5
:confused: I'm new to excel coding. Have combined some codes for my Quotation file to work. Now, my boss thought of adding an option for when I click the BRACKET COST button, the item cost would change into the amount that i will link from a worksheet within this workbook.
OP2asAU
OP2asAU


here's a part of what my worksheet looks

OP2asAU[COLOR=
OP2asAU


I want this button to "CYCLE" the NET COST and BRACKET COST back and forth.

My rows are dynamic by an offset function for the tabulated cost and the SUM COST (for the TOTAL QTY and TOTAL NET) button is the last part to compute the values.
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,213,494
Messages
6,113,974
Members
448,537
Latest member
Et_Cetera

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top