locked
Enter Text to Un-specific Row RRS feed

  • 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

  • They'll help you over here.

    http://answers.microsoft.com/en-us/office/forum/excel

     

     

     



    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    • Proposed as answer by Mike Laughlin Monday, August 29, 2016 11:59 AM
    • Marked as answer by Just Karl Tuesday, September 6, 2016 2:02 PM
    Friday, August 26, 2016 8:06 PM

All replies

  • Looks like you should try in an Excel (Office) forum for help.

    Here's forum for Small Basic programming.

    Friday, August 26, 2016 12:01 PM
  • They'll help you over here.

    http://answers.microsoft.com/en-us/office/forum/excel

     

     

     



    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    • Proposed as answer by Mike Laughlin Monday, August 29, 2016 11:59 AM
    • Marked as answer by Just Karl Tuesday, September 6, 2016 2:02 PM
    Friday, August 26, 2016 8:06 PM