none
Enter Text to Un-specific Row

    Question

  • Hello Everyone,

    I want to do some innovation with my report. For example, I have the tabulation of cash in column "D" with the total amount at its bottom row. Beside the total amount is the text "Cash Balance" in column "C" and i want my name to automatically appear beside the word "Cash Balance" in column "B". Let put it this way, if the word "Cash Balance" is in row "C4" my name will appear in row "B4". Please take note that the word "Cash Balance" has no specific row since it will adjust depending on the data above it. So if the word "Cash Balance" is in row "C20" my name will appear in row "B20". The challenge is, even they deleted my name it should appear again if they switch to other sheet of the workbook then switch back to the previous worksheet. Thus anyone can do the code for this one please.

    Thank you very much,

    Zxnjo


    • Edited by Zxnjo Friday, August 26, 2016 3:15 AM
    • Moved by litdev Friday, August 26, 2016 5:31 PM
    Friday, August 26, 2016 3:14 AM

Answers

All replies