Posts by Carim

    Re: Repeat columns show variations in separate column


    hello again,


    The formula is an array formula ... which means that instead of using the Enter key ... you need to simultaneously use the 3 keys : Ctrl+Shift+Enter


    As a consequence, Excel will display "{" before the = sign ... and "}" at the end of the formula ...


    HTH

    Re: Copy paste with IF statement problem


    Quote from Sarb;753051

    Wait.... sorry you totally fixed it im just stupid i just recognized it now omg thank you!!!!! you are the absolute best!!!!!!!!!!!!!!!!!!! i could kiss you for this!!!


    Do not hesitate ...!!! :kisshear:

    Re: Two dynamic drop downs with specific list selections


    If you have you resin types constantly changing ...


    1. You do need to use range names dynamically defined ...


    2. You do need to make sure each column has Unique codes ...(see Asia ... added a 2 to XX ... to make sure it is unique...)

    Re: Two dynamic drop downs with specific list selections


    Hi,


    You can hide the Locations worksheet if you want ...


    But, you do need all the info which is found in this worksheet ... for all your drop-downs to function properly ...


    Unless the Resin worksheet can be considered as a safe place to define the range names ... (see attached version 2)


    HTH

    Re: Copy paste with IF statement problem


    Quote from Sarb;753042

    Correct, and will this work if the date changes too? like if now lets say we are on Jan 2nd will it see that its a different date and approve it because the balance for date to will be 40?


    Do not hesitate ... to test the latest workbook as much as you want ...:hammerhe:


    Let me know if it is now in line with your expectations ...

    Re: Copy paste with IF statement problem


    For the sake of clarifying things out ...


    Let's make sure the final objective is clear ...


    Sheet 1 is your input sheet for tracking events


    Sheet 2 is your archive sheet where you are storing your events


    Now, with this structure, which are precisely the rules you want to apply ???

    Re: Range in VBA Address


    Hi,


    You can test the following


    Code
    1. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    2. If Intersect(Target, Range("$H$10:$H$150")) Is Nothing Then Exit Sub
    3. Call OpenCalendar
    4. Cancel = True
    5. End Sub

    Re: Copy paste with IF statement problem


    If you replace the Column F ... by the Column A in the formula ... you will get the sumif() function to perform on the date ... instead of the name ...


    For your info, it is exactly what this formula was ... just before your last request ...in post # 14 ...

    Re: Copy paste with IF statement problem


    You are 100% right ... there was an error in Sheet 2 Cell D2 ...


    In this cell, the formula should be :


    =B2-SUMIF(Sheet2!$F$2:$F$50,F2,Sheet2!$C$2:$C$50)


    Then, you need to copy it down ...


    HTH

    Re: Copy from first column till last column Error


    Hello,


    You should try to replace the ampersand [COLOR="#FF0000"]&[/COLOR] by a comma [COLOR="#FF0000"],[/COLOR]


    wb.Sheets("Flat Table2").Range(Cells(1, 1)[COLOR="#FF0000"],[/COLOR]Cells(2, LastCol)).Copy

    Re: Copy paste with IF statement problem


    Glad this is helping you out ...


    A tiny modification for the type of absence in column G ...


    Files

    • LM WIP.xlsm

      (18.23 kB, downloaded 109 times, last: )

    Re: Copy paste with IF statement problem


    Quote from Sarb;753013

    Thank you so much for your reply, and it worked for the series that you mentioned it in. however if you look in the original excel sheet i uploaded the "approved" text in cell P11 also has a formula based behind it would it work with the formula as well?


    Regarding the text "Approved" ... in order to avoid a circular reference, you have to decide which sheet (and cell) is holding the source ...