I have 26 worksheets very similar to the attached.
The $ price shown in Zone WX is my cost price. I want to increase this by 60% i.e 1.6 and replace the Zone WX price with my selling price. So if Zone WX price is $100 it will become $160.
The column Direct Container, where it appears, needs to be removed.
I don't want to see a string of 0 where a formula is just copied down. I don't want to see that my price is arrived at my multiplying by 60%. The selling price just needs to be there for the customer to read.
Better still if your bid says that you will do a macro where I can change the mark up perhaps from 60% to another number.
This is not a huge project so please bid sensibly.
The file is large so you need to make sure that you can email and send a file of this size. I can't zip a file. Can never get it to work.