+ Reply to Thread
Results 1 to 3 of 3

print function aswell as help on basic coding if you'd please.

  1. #1
    Registered User
    Join Date

    Exclamation print function aswell as help on basic coding if you'd please.

    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 !

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    What makes you think you need code for this?

    For your first question couldn't you just use filters?

    For your second can't you just use a formua?

  3. #3
    Registered User
    Join Date
    Filters could work easily for the first one, thanks.

    but for the second one, the only reason i'd prefer to use coding/formulae is because the spreadsheet might change a lot, making use of coding will keep it dynamic, instead of changing the formula everytime i change the spreadsheet.


    Ok, let me rather ask this then. How do I create a formula, that works in the following manner AND that I can use over and over again.

    I have values that are located in C7 D7 E7 F7 G7 and I7 being my answer. I have a formula to calculate my desired answer, but I dont want to type into 700 lines the exact same formula that runs in c8 - g8 ; c9 - g9 and so forth all the way down to c700. Is there a simpler way to do this? I reckon with a bit of knowledge i can give each cell an integer/constant and then repeat the formula through the entire column I. The problem is I am lacking that coding knowledge.

    Anyone please assist!
    Last edited by deewhyoh; 07-22-2007 at 06:01 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1