• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. R

    Need basic formula help

    Works thanks!
  2. R

    Need basic formula help

    Sorry I can't get a grasp on writing basic formulas, I'll upload what I need help with Thanks, Ray
  3. R

    two formulas in one cell

    Quick reply! Works! thank you, is there a way to hide the number 150 till the formula's used? Thanks Ray
  4. R

    two formulas in one cell

    Hello I'm trying to figure out how to get a number then if the number is less than a number then number Heres what I'm attempting: cell I8 =SUM(G8*H8) **this gets my number, but in the same I8 cell how do I determine if the number is less than 150 then 150 I've been trying to figure it out...
  5. R

    Copying specific cells from sheet to another same formated sheet

    Can I ask you how you came up with the solution so that maybe some of it will stick up stairs? :)
  6. R

    Copying specific cells from sheet to another same formated sheet

    Hello, There's 5 other people that will be using it, some would have trouble copying & pasting It would be nice if it was automatically done for them on the "invoice" sheet I have to modify it further as well Thanks, Ray
  7. R

    Copying specific cells from sheet to another same formated sheet

    Sorry I've tryed and can't seem to grasp how to do it I need to copy format, formulas and user input data and from A6 to I53 from sheet 1 to sheet 2 heres a link to the file I'm trying modify: http://www.muzecraft.com/excel/ Thanks!
  8. R

    Automating estimate sheet

    Meanwhile I'll try to interpid your coding :)
  9. R

    Automating estimate sheet

    Hi, I'm altering the labour rates in the example you uploaded but it doesn't change the value of the labour, the labour cell is calculating the material as well? Thanks Ray
  10. R

    Automating estimate sheet

    I'm sorry I'm not fully understanding how your formula works If I understand correctly it is based on matching text? I have it going backwards as you can see in the file below :)http://www.muzecraft.com/excel/testEstimate5.xlsm Its getting close! Thanks! Ray
  11. R

    Automating estimate sheet

    So I'm guessing this would be the template minus the formulas 3 questions, How would I direct the word Labour to H4 cell? next question is that with each room that Labour cell (H4) would change, there must be a formula for that? the same question would be for the Material cell D4 which would...
  12. R

    Automating estimate sheet

    Hi I estimate flooring and I need to estimate and total one room at a time for insurance companys on a single spreadsheet, each room is different and may use more lines or less lines. I made an example of how it needs to look: http://www.muzecraft.com/excel/testEstimate3%20.xlsx It would be...
  13. R

    how do I automatically add a new formatted row

    Ok thanks I'll do that
  14. R

    how do I automatically add a new formatted row

    Thanks! now my big question.. I estimate flooring, I need to estimate for insurance companys one room at a time, How would I get it to summarize seperating labour from product (Pst & Gst) and then sub total it then start the whole procedure again with the next room on the same excel sheet...
  15. R

    how do I automatically add a new formatted row

    Sorry I got it to work :) Thank you
  16. R

    how do I automatically add a new formatted row

    Converting to a table looks like the right way to go, how do I keep the existing =SUM(G2)*(H2), I convert it but it stops adding after I do that Thanks
  17. R

    how do I automatically add a new formatted row

    how do I automatically add a new formatted row when I hit enter to finish the original row here's the row I want duplicate http://www.muzecraft.com/excel/testEstimate%20.xlsx I'll have another question as soon as I understand this one :) Thanks
  18. R

    Auto add date once

    Hello, I'm trying to figure out how to use the current date automatically only once for a estimate quote sheet I want to make out a quote with a 30 day expiry, right now if I make a quote and save it, reviewing it would change the saved date to the current date. I hope I'm making sense, the...
Back
Top