Posts by Ingo_Ingo

    Re: Copy and rename sheets


    Quote from patel;685947

    you started with 2 sheets, now please, explain better your problem


    The problem is the same, from first post, but do not expect answers like this: "You CAN delete the existing sheet, THEN copy the new". A code to do what I asked in the first post would be perfect.

    Re: Copy and rename sheets


    How easy would it have been to be found quickly and have them removed. But I have over 150 sheets in the file. I would not have asked for help in this forum but so ...

    Re: Copy and rename sheets


    Hi,


    Thanks for the reply but if you want to overwrite the sheet how do? I wrote that I want to create 2 sheets (actually more, but I hope I can change the code :wink:).

    Hi,


    How can I copy 2 sheets - named A and B - (in the same file) and rename them say AA and BB, but if sheets exist to show a message whether to overwrite or not. If answer is to overwrite then overwrite else exit sub.


    Thank you.

    Hello,


    In range (B2: F10) have numbers. In column G we mean the sum of the rows in G2 = SUM (A2: F2) in G3 = SUM (A3: F3), etc.
    In B11 = AVERAGE (B2: B10) in C11 = AVERAGE (C2: C10) etc.
    If C4 fill it with a color I would like the amount of G4 to decrease with cell value and vice versa if you get normal color in cell the sum of column G to modify with the cell value. The same for AVERAGE of the line 11.


    For example say in C4=10 and sum in G4=100, if I change color of cell C4, sum in G4 will be 90, if I remove color of C4, G4 will be 100.
    In same way for AVERAGE in row 11


    Thanks.

    Hello,


    Because I have many formulas in a spreadsheet trying to reduce their number.
    How can I reduce / efficiency this formula:


    =IF(AND(B4>=1900;B4<2000);AB20;IF(AND($B$4>=2000;$B$4<2100);AC20;IF(AND(B4>=2100;B4<2200);AC20+1;IF(AND(B4>=2200;B4<2300);AC20+2;IF(AND(B4>=2300;B4<10000);AC20+3)))))

    Re: Index &amp; Match formula for a number in a string



    Hope this G5 (bold) is a typo.

    Re: Different rounding formula


    No,


    I need a formula to to like this:
    If a number (in cell A1) has no decimal in B1 to put that number (Eg A1=199 => B1=199)
    If decimal are between 01 and 49 in B1 to put that number and decimal must be 5 (Eg A1=3.23 => B1=3.5)
    If number in A1 is say 2311.5 in B1 it will be same number (2311.5)
    If decimal are between 51 and 99 in B1 it will be number from A1 increased with 1 (Eg A1=338.62 => B1= 339)

    Re: Different rounding formula


    Hi,


    Thank you for replay.


    In cell A1 could be any number and I need a formula to return in B1 that "special" number :
    If number in A1 is 125.17 (everything between 125.01 and 125.49) in B1 will be 125.5
    If number in A1 is 125.50 in B1 will be 125.50 remain same number
    If number in A1 is 125.69 (everything between 125.51 and 125.99) in B1 will be 126
    If number in A1 is 125 Or 125.00 in B1 will be 125 remain same number


    Hope now is clear.