hey sorry, i didnt get a email notification, just looking over this now
Before diving into the intricacies of re-coding everything ....
Safer to get a formal confirmation :
- F to J
- G to I
- H to K
- I to G
- J to H
- K to F
- L to L
that is correct
In addition to your confirmation for all the Columns to be permuted ... you should also clarify your Bin Price calculation process ...
Indeed, by using a Data validation for prices ...
1. on one hand, you do NOT have a formula to adjust neither for 13% Sales Tax nor for the $15 charge per Extra Day ...
2. on the other hand, indeed the macro can automatically perform these adjustments ... BUT ... there is no way back ... (which is automatic with a formula ...) and, as a consequence, any price correction will require re-selecting a ' basic ' price in Column C ...
Let me have your comments
Im okay with selection 2!!!! Thank you!!!! Sooooooooooooooooooooooooooooooooooo MUCH