Questions

How to export Excel 2007 rows to another worksheet Comments boxes?

+
0 Votes
Locked

How to export Excel 2007 rows to another worksheet Comments boxes?

Bridg389
1-How to Export Excel 2007 rows to another worksheet's Comments boxes? so I don't have to manually add them to comments boxes.
2- and if this new cell (with comment) has certain data in there it will have green circle in there, if not the it has red circle.
3- and in future if I change the wording on that comment I can click on it will change to green light.
I created an Excel sheet that looks like a switch (in the server room) that I want to say which port is connected to what server and if it is an active port or not. This is the purpose of this. Thank you.