Hey guys
Need some help, I've got a few basic macro/functions I need to perform, but my brain is melted.
First of all, I'm creating an equipment schedule for cost-estimating purposes. The thing is it's a very long list, so when I want to print it I'd prefer to have the cells I haven't used to "disappear" . I reckon it's a very basic command. I can probably 'link' it to one of my columns and viola! If you could please supply me with the command and a basic explanation on how it works please :$
Second things second, this should also be easy, but I'm far too unfamiliar with VB coding to use a proper macro for it. And using a formula for a dynamic sheet is such a pain! Basically, I have column A through I. B being my equipment description, C = Quantity, D = Material Cost, E = WorkshopCost, F = Install Cost, G = LOA, H = Margin and I = Selling.
Now what I need is for column I(selling) to be: ((QUANTITY*D 'materiacostl - this must be seperately calculated' + (D+E+F)) * MARGIN and then add any margin into H to change the total of I accordingly. So it's my quantity times my materialcost, then the sum of my workshop+install+loa and lastly add the margin. the margin I can't figure out, cause 25% even when using formated cells give me a weird value.
Any help would be appreciated guys, thanks !
Bookmarks