I have a multi page work book and one of the sheets is for marking the status of personnel I reference their status in another sheet, but I would like not only that info to show but any comments that are attached to the referenced cell. Any ideas?
I am a middle school math teacher. I bought Power Excel (2019 edition) and was instantly overwhelmed. I am sure the book has the information to help me but I don't know what is called to do what I want.
We have to post grades with comments 4 times a year. The list of comments we can use are...
I am working with two workbooks. In the first workbook, I have a worksheet that lists 100 ip addresses. I have another workbook that has 100 tabs. Each tab matches one of the ip addresses that are on the first workbook. Also, each tab in the second workbook has anywhere from 10 to 30 rows of...
I have the results of a survey in an Excel spreadsheet, like this:
Flowers and Decoration Team
Hello, I cant figure out how to do a "double search" in a column. Conditional formatting would be better but entering a formula along a row could do. Hopefully I can explain what I am tryin to do. I am trying to find duplicates within a column (F through S), then in the duplicate row see, if...
I have a column that has comments and I would like to combine those comments into one cell which =concat does but how can I add a comma and space between the comments from each line
Column 1 = Topic Column 2 = Comment
Not every row has a comment though
Your help would be greatly appreciated
I would like to show a threaded comment (with notes it is straightforward, we put them on 'visible=true') when activating a sheet.
Is there a line of code to show those threaded comments ?
I noticed there is a "show comments" in review tab but recording macro does not help. Even if I add...
I have a simple excel file from which I'd like to share just certain rows and no comments with my colleagues in a separate file stored on a common file area. I'm thinking about creating a copy that is automatically updated at least daily in which some of the rows and all of the...
Is it possible to link an Excel file to the comments being generated in a Word file? I have a situation at work where we have a Word document that is being used by several different people who are adding comments to it.
One of the guys is using an Excel file to create a snag list of issues...
So I've got a bunch of comments in a spreadsheet and all the comments are of variable length. I try not to change the size of the default box if I can avoid it cause I've noticed if I increase the size or move it, the next time I look at that comment, the box has changed size and I have to...
I am using the built-in function Transpose to convert an array to a string and would like to use the current selection
ie change this
Comments = Join(Evaluate("TRANSPOSE('Base'!A1:A10 )"), vbNewLine)
Comments = Join(Evaluate("TRANSPOSE(Selection )"), vbNewLine)
The latter gives a...
Good afternoon Guru's
I'm racking my brain with the best way forward on this. I have two spreadsheets (similar examples attached), one holding source data and the second is used for reporting. The source data comes from another source and therefore doesn't contain comments (column G). The...
I need help to generate excel formula for below table.I need to put comments "value Zero" if my column"A" value nullify. below is the table. Please help me to get formula for this.
Value zero for 400
Value zero for 400
I have a sheet with a lot of comments which show additional information. With al the red right top corner triangles for every comments it gets very messy.
Is there a way to not show these indicators? I found the 'no comments and indicators' function in Excel but this automatically removes...
I'm designing a sheet that is to be used as a tally for a strawman poll before a real vote is held on some projects being considered at my company. Some of these polls will have comments on them when returned. I'd like to list all comments, though most will be blank with no...
Hello! I have a userform with two sections. There are 4 checkboxes in each section with the idea that they will be pre-populated comments that will fill into a textbox. I am able to get it to populate text into the textbox when one box is checked however the way I have it written only allows for...
Error... This, this, and this
Error. This, this, and this
In order - that, that, and that
Where, when, why, and how
Dear All, good morning,
I have a spreadsheet and I have added comments. I have - up to now - been able to edit the comments without problem.
Today, I have tried to edit the comments but it won't allow me. When I right click / edit comments, the comments box won't open.
Could someone advise...
An Excel spreadsheet containing any 'notes' (previously known as 'comments' in some earlier Excel versions) is slow to scroll up and down when using the up/down arrow keys. For example, even on a new workbook created as a blank workbook, after one 'note' is added (right-click, new note) in...
Excel 365 here. The newer Excel version changed the old “comments” as “notes” (renamed this way), and added a new feature under the mention “comments”, which works like a thread with possible replies, where on top of input text, the autor is mentionned with a timestamp.
I’d like to...