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

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Forum statistics

Threads
1,214,394
Messages
6,119,262
Members
448,880
Latest member
aveternik

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