Posts by rachitm

    I am looking for a formula function or a vba code where:



    - In workbook1 find the first cell that is empty between range A7 -
    A10,
    - In workbook2, in Range G10- G13: find the word "Day1".
    - If the word "Day1" exists in cells G10 or G11 or G12 or G13, copy
    the particular cell or cells where "Day1" exists to the first found
    empty cell or cells in range A7-A10 in workbook1.



    Lets suppose cells A8, A9, A10(workbook1) are empty cells, that means
    A8 is the first empty cell.
    And G10,G11,G12, G13 (workbook2) have the word "Day1"
    Then,
    Copy cell G10 into cell A8
    Copy cell G11 into cell A9
    Copy cell G12 into cell A10



    Please let me know if this explanation is confusing.... and I can try
    explaining again.



    Appreciate all help!