Can You Turn Cell Contents Into A Comment

Dec 19, 2008

I was wonder if there was a way to automatically turn the contents in cell B2 into a comment for cell A2?

Is there a formula or some kind of automated macro or function?

View 9 Replies


ADVERTISEMENT

Copy Contents Of Multiple Comment Boxes And Paste In Single Comment Box

Mar 13, 2014

how to copy the contents of multiple comment boxes and paste in a single comment box.

The big picture is that I have a number of cells with numerical values in and text in comment boxes. I want to be able to click a button to copy the contents of the comment boxes and paste them, along with the numerical value from the cell, into a single comment box, ordered by highest to lowest value within the comment box, then delete the original cells and comments.

I am quite new to VBA but have been coping quite well so far with information of the web and analysing recorded macros.

View 6 Replies View Related

How To Link Contents Of Cell To Comment

Jan 19, 2013

if its possible to link contents of a cell to a comment.

IE - Whatever the cell contents in sheet 1 A5 would reflect in the comment in sheet 2 A5 Im happy if its coded that would work.

View 4 Replies View Related

Extract Contents Of Cell If Greater Than Zero To A Comment

Dec 30, 2009

I am trying to extract contents of cell to a comment.

Column K is Overtime Hours
Column L is Regular Hours

I have managed to create the following macro that will copy the contents of a cell in Column K and put it as a comment in Column L. But I am needing the macro only to create a comment if the value of the cell in Column K is greater than 0

View 2 Replies View Related

Insert Contents Of A Cell Range Into A Single Comment

Feb 15, 2009

I would like to Insert the contents of a Range of Cells into a single Comment. ie:
The contents of Range A1:A50 into a Comment placed at F1. Is there a Macro that will do this?

View 3 Replies View Related

Excel 2010 :: Add Comment To Cell Without Changing Cell's Contents?

Mar 13, 2012

How, via VBA, would I add a comment from a userform (text box name: txtReason) into a cell that may already have a comment in it? I would like to keep the comment that is in the cell and then have the program add a "/" and the next comment from txtReason..

(using excel 2010)

View 2 Replies View Related

Paste Copied Contents Of A Cell As A Comment In Another Cell

Sep 7, 2012

I am working on a database and trying to remove duplicates. When there are duplicates, I want to take the contents of one cell and copy them as a comment on the cell above (or below).

I tried to work on a small macro to do so, but the contents of the cell cannot be copied (it comes out as a blank).

The long way is to 'double click' in the cell, Ctrl+A, cut, click the cell above, Ctrl+F2, paste. This way is very long as I have thousands of duplicates.

View 4 Replies View Related

Sort Data By Comment Contents / VB Macro

Oct 3, 2009

please have a look at the attached file.

I want to sort the data by the comments in Column B, specifically by comments that do contain a telephone number, whether it is "Telefon" ( e.g. in B17 ) or "Phone" ( e.g. in B24 ) or "Téléphone" ( e.g. in B16 )

I know a Macro written in VB could do that.

View 8 Replies View Related

Turn #DIV//0!” To “0” Or Even Turn It To A Blank Cell

Nov 6, 2009

I have a workbook which is set up to take an average heart rate of a participant from a series of data points. I have set the spreadsheet up before I have collected some of the data. (so I can review the project at the 3 months period and its an ongoing project).

The problem is that if there is no data in a participants column then excel correctly gives you readout of “#DIV//0!”. On my results page this #DIV//0!” makes it hard to read the spreadsheet. Is it possible to get excel to turn #DIV//0!” to “0” or even turn it to a blank cell?

View 5 Replies View Related

Conditional Properties: If A Number In A Different Cell Is Above A Certain Number It Will Turn Green And Another Cell To Turn Red

Dec 10, 2008

can I set a cell in excel so that if a number in a different cell is above a certain number it will turn green and another cell to turn red. I have attached the file.

View 4 Replies View Related

Compare Cell Contents With Given Range Of Contents

Dec 30, 2013

I have attached a workbook stating my problem.

file1.xlsx‎

View 10 Replies View Related

Return Contents Of 1 Cell Based On Contents Of Another Cell?

Mar 12, 2014

I thought this was a pretty simple formula but I am having difficulty creating it. I am attaching a little test spreadsheet. Sheet 1 is where the data will be entered. The Reimbursed column has a drop down choice of yes or no. The next 2 columns are the cost of registration and the cost of accommodations. On sheet 2 is where I would like the formulas. So in cell A4 I would like a formula that says if B3 on sheet 1 is Yes populate this cell with the contents of Cell C3 only, B4 of sheet 2 would then be B3 if A3 on sheet 3 is Yes and so on with the Not reinbursed if sheet 1 the Reimbursed column is no.

View 3 Replies View Related

Macro Or Equation To Have Cell Turn Red / Green Based On Value Of Another Cell?

Oct 23, 2013

I am attempting to create a ROI calculator for my place of work. I want a blank cell to fill in green or red based a cell below it being equal or greater than 5.0%. What is the Macro or equation to do that?

View 5 Replies View Related

Can I Turn A Cell Into A Drop Down

Sep 7, 2009

I know I can right click in cell and choose from the items, but can I actually make the cell a drop-down box, like on websites? Meaning, can I choose which options/numbers/letters/choices I want in the drop down, and be able to right click and highlight one?

View 10 Replies View Related

Autoupdate Cell Comment Based On Cell Input / Dynamic Cell Comments?

Aug 16, 2013

I'm wondering if it is at all possible to have a cell comment automatically update depending on what data is input in the cell (via user input, VLOOKUP, etc.)?

For example, if cell A1 contains the text "CHARLES" with a comment saying "Employee of the Month", and is then subsequently updated with the new text "JOHN" (again, via direct input, a VLOOKUP, data validation, etc.) is there a way to have the comment automatically update to say something else, such as "Team Lead" for example?

I've considered using VBA to accomplish my goal, but am unsure how to compose an effective code to do so. I've also considered perhaps creating a named table filled with all the different comment possibilities I would like to have used in this cell and then inputting a formula in either cell A1, or the comment contained therein, that would then call the corresponding text from that table based on the data in cell A1. Honestly, I'm not sure that what I'm trying to do is even possible;

View 4 Replies View Related

Turn Row Color Based On Cell Value?

Dec 23, 2013

how do I turn a row range a different color based on an answer in a cell value for example:

If B4 = Wont have
Turn grey the range C4:G4

View 3 Replies View Related

If Cell Has X Turn Into Number And Concatenate

Jul 4, 2009

Example is in the attch: Book11.xls. This formula works but if there is no number 4 then I don't want comma after 1, or 2, or 3, How avoid it:

results

1,2,3,4
1,2,
1,2,3,
3,4
1,
4
2,3,

(red , need to be removed)

View 5 Replies View Related

Turn Part Of Cell Into CAPITALS

Sep 30, 2007

I run a catalogue of music (thousands of records) made in excel
where I have in the first cell the name of the band + album + format,
something like this:

Pearl Jam - name of the album - CD

how can I turn automatically all names of bands into CAPITALS, in
example:

PEAR JAM - name of the album - CD

Is there a way to turn in CAPITALS all text from the beginning of a cell 'till the symbol with spaces on both sides ( - ) of each cell ?

I know how to turn the entire cell into CAPITALS using the formula =upper(column nº) but not just part of the cell.

View 9 Replies View Related

Make Text In Cell Turn Red After The 90th Day?

Apr 21, 2013

I am calculating service dates for trucks: Need to make the text in a cell turn red after the 90th day? A

View 3 Replies View Related

How To Turn Range.find Into A Cell Reference

Dec 9, 2009

I am writing a function that opens up an external excel document, identifies a string in a certain range and then i also want it to return a cell reference for that string including the number of rows beneath the cell that the string was found in.

View 6 Replies View Related

Turn Blank Cell To Hyphen In Particular Cell?

May 12, 2014

I want to add a hyphen to 2 particular cells if they are blank. The form is populated from another software package with dimensions. If Columns D and E have any blank cells, want to insert a hyphen. Can't use VB because the particular software package will only output to a template with .xlt

If can't do with Conditional Format, then okay I can tell the inspectors to use add by hand

View 5 Replies View Related

Use Conditional Formatting To Turn Cell Red If Any Cells Above Are Blank

Nov 3, 2009

I have a formula in A56 that adds cells A1:A54. I want to use conditional formatting to highlight A56 if any of the cells in A1:A54 are blank. I am unsure how to do this.

View 3 Replies View Related

Cell Formatting - Turn Entire Row To Light Gray

Dec 13, 2013

IF the list value in D2 is = to MT,GP,or H then I need the entire row 2 to turn light gray.

View 6 Replies View Related

Add Comment To A Cell

Feb 18, 2008

I have some code that finds the appropriate string for a comment from another sheet. I then want to add the string to the appropriate range selection but am encountering an Object Variable or With Block Variable Not set on this section of

Range("C" & i).Select
ActiveCell.Comment.Delete <== Here Or the Next line
ActiveCell.AddComment (Commenta)
ActiveCell.Comment.Shape.TextFrame.AutoSize = True

Where Commenta is the string value I want to add.

View 3 Replies View Related

If Cell Equals New PO Turn Entire Rows Text Red And Bold

Mar 2, 2014

Code that will turn the entire rows text bold and red if a cell in that row has the word.

New PO

View 9 Replies View Related

How To Reference A Cell In Another Workbook And Return Cell Value And Comment

Nov 2, 2012

What is the best way to reference a cell in another workbook and return the cell contents and the comment on that cell. I would like the comment to come across as a comment in the new workbook becuase the comment is actually a picture.

Hope this makes sense. I did find a macro through googling but I couldn't get it to work? I don't really want to copy and paste because eventually I have hundreds of sheets & thousands of cells to refer to.?

View 2 Replies View Related

Making 1 Cell Equal Another Cell Including Its Comment?

May 18, 2014

I have a spreadsheet with some cells which return values using INDEX and MATCH to bring back the entire details of a person based on there membership number. However I require the comments to be attached with the returned values. The comments have there image in, rather than just text.

I have found some answers with vba, which do the process, however you had to manually enter the cell, from which the comment was to be copied from, into a pop up box. This involved finding the box myself to then select the box to take the comment from. In doing this I had found and read the comment, which is the is the process I'm trying to bypass.

View 8 Replies View Related

To Copy A Cell Content To A Comment Into Another Worksheet In The Same Cell Ref

Jun 25, 2008

I need to copy a cell content to a Comment into another worksheet in
the same cell ref.

sheet1
A1 = apple
A2 = orange

Sheet2 - target
A1 = comment (apple)
A2 = comment (orange)

View 9 Replies View Related

Add Picture To Cell Comment

May 15, 2008

i need to have a way to link a small picture/thumbnail to a cell. so that there is a way to preveiw it. Ideally like what happens with the comments where you hover over the cell and the comment would pop up. or failing that may be a cell linking to the image.

View 8 Replies View Related

Lookup For Cell Comment

Jan 16, 2009

make the contents of the cell comment box dependent on the cell contents? eg if the cell contents = 2 and a seperate table says 2 is "poor" can it automatically populate the comment with "poor" ?

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved