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

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Forum statistics

Threads
1,213,561
Messages
6,114,315
Members
448,564
Latest member
ED38

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