• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hyperlink or fomula to add result in comments of a cell

Navi

Member
HI Team,

Good evening. Need a help with Excel summary.

I have few sheets like active employees, New Hire, Attrition and few more sheets. for all the sheets I have prepared a summary by updating the numbers using countif of new hire and separation as per the department. Currently What I am doing is if i enter the new hire number as 5, i search for the 5 employee id and put it in the comments of the cell so people who sees can see the comment who have joined.
Is there any way that the cell can automate the countif output and update the same in comments or any hyperlink types will help. I am not sure on w

Thanks in advance.
Naveen
 
Back
Top