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


ADVERTISEMENT

VBA - Display Current Date Based On Contents In Neighboring Cell / No AutoUpdate

Dec 6, 2013

I have two columns, column Q and R. Column Q has Data Validation set, where you can only choose one of four options in any given cell between rows 2-250,000. When "Complete" is chosen, the cell turns green. Now when "Complete" is chosen in column Q, I need the cell next to it in Column R to auto-fill today's date. However, the date should not update to the next day. So if the cell autofills to today's date, which is 12/6/13, tomorrow, when the date changes to 12/7/13, the cell still reads 12/6/13.

View 4 Replies View Related

Dynamic Input Cell

Aug 30, 2007

I am making a basic inventory tracking worksheet which consists of 2 sections. The first section has all the unassembled parts and quantities and the second shows the total assembled parts. I am trying to track unassembled parts and assembled parts simultaneously. I would like to have a cell that I can put a number in (which would represent the number of assembled products manufactured that day) and adjust the totals in both parts accordingly as they are made. For example, if I start the day off with 5 units of all the parts unassembled and manufacture 2 that day, I want to be able to put the number 2 in a cell, hit enter, and then have the unassembled inventory decrease by 2 (per part) and have the assembled inventory increase by 2.

View 9 Replies View Related

Excel 2007 :: Restrict Cell Input Based On Another Cell Value

Jan 22, 2013

I am working in both 2003 and 2007 Excel.

This is a simplified version of my worksheet:

I have two cells, A2 and B2. When I enter a numeric value into B2, I want it only allowed when certain text values are in A2. I.E.: Allow any value in B2, but only if A1 is either "SYDN or "ADEL".

Now using info found in an old post, I can achieve this with a combination of data validation and code:
=OR(A2="SYDN",A2="ADEL") for the validation and for the code:

[Code] ......

The only problem is I also need to reset B2 if A2 changes to invalid data as a result of some other input to that cell (A2). In other words if B2 is showing "1" already and A2 were to change from "SYDN" to say "LOND", then B2 needs to be cleared. If A2 changed to "ADEL" then it doesn't need to clear but it is ok if it does because it is fine to re-enter "1" into B2 again.

I have attempted to attach a sample worksheet : Xl0000003.xls‎

View 4 Replies View Related

Change Result Cell Format Based On Input Cell Value

Mar 24, 2007

Macro Based on an input cell’s (e.g. B12) setting of “yes” or “no”, format several other cells (e.g. B20:G20, B23:F23, C26:J26) as follows: keep the existing yellow shading if input cell is “yes”, change to grey shading if input cell is “no”. I would like this macro to run automatically whenever the input cell value is changed.

View 2 Replies View Related

Dynamic Range Based On Cell Between A Header And Footer Cell

Sep 2, 2008

I need to create a dynamic range based on cell between a header and footer cell. The header cell ( A8 ) will remain static, however, the footer cell starts at A10 and then will move down as rows are added.

View 9 Replies View Related

Formula For Cell Result Based On Other Cell Input

Sep 3, 2007

I'm trying to work out the way of having a cell give a result based on what has been input into two other cells.

Basically I'm doing up a risk management spreadsheet. I need to have in one cell the LIKELIHOOD of an incident, in the second cell, the CONSEQUENCES of it happening and ending up with a RISK MANAGEMENT ASSESSMENT in the third cell.

View 9 Replies View Related

Cell Values Based On Input Of Another Cell And Sheet

Apr 2, 2007

I want to tie the values of some cells on Sheet 2 to what's put in into corresponding cells on Sheet 1. Example

If Cell B3 on Sheet 1 has the string "B off" put in, Sheet 2 should automatically get "R1" in cell B12, "B off" in cell C12 and "ID123456" in cell D12. If cell B3 on Sheet 1 is empty, B12:D12 should be blank.

View 4 Replies View Related

Restrict Cell Input Based On Text Of Another Cell

Jan 29, 2008

I have two coloumns on a worksheet. In the first column I have data validation drop down list. I want to be able to: if the first column "Other" is chosen then the next cell will allow text for description, if anything other is chosen in the first drop down list cell then I want the next ( text for descritption ) cell to be resticted.

View 4 Replies View Related

VBA To Add Comments Based On Cell Text

Jun 5, 2014

I have a VBA that can add a comment based on the cell value, however, I need it to do it for the whole worksheet and not just one cell. I am pretty new to using VBA's, so this is the best code I could find that would perform what I need. If there is a way to have it do run a vlookup, instead of me listing all the cases, that would be great as well.

VB:
Sub AddComment()
Dim strText As String
With Range("s6")
Select Case UCase(.Value)
Case "UPT": strText = "UnPaid Tardy/Late"

[Code] .....

View 5 Replies View Related

Comments Based On Cell Values

Aug 4, 2008

I would like help with a formula or VBA that would show comments based on cell values.

For example, if cell A1 has cell value '2143', I want comments to be 'Twinkle Twinkle Little Stars' and if cell D1 has cell value '4567', I want 'Humpty Dumpty Fall on a Wall', and etc. How can I do it? I have about 35 different cell value categories. I appreciate any help you can give me. Thanks in advance for your time and effort.

View 9 Replies View Related

Dynamic Cell Contents Based On An Other Numeric Cell Value.

Dec 3, 2009

cell A1 is equals to B1 because the cell C1 contains the number 1.
Now if i change the value of the C1 to 2 how can i make the A1 shows the value of the B2 ?

Just like. [A1]=B(C1-content)

View 3 Replies View Related

Insert Cell Comments Based On Value In Another Workbook

Jun 16, 2008

I need a macro that will do the following scenarios.

1. I have two workbooks.

a. The first contains a sheet with " Names" listed in column A.

b. The 2nd contains a sheet with "Names" listed similar to first workbook. The only difference is that the 2nd workbook contains 2 other columns, "Age" in B and "Address" in C.

2. Only the 1st workbook is opened.

3. When I click a name in the 1st workbook, it will look for a match with that of the 2nd workbook.

a. If there's a match, it will copy the corresponding "Age" and "Address" and display them as comment to that name in the 1st workbook.

b. Else, it will display a comment that no record was found.

View 3 Replies View Related

Restrict Cell Input Based On Another Cell Value

Jul 27, 2009

I've written a spreadsheet and am wondering if there is a way to permit data entry in a cell, contingent upon another cell being populated.

In simple terms, you can't enter data in cell X, until cell "Y" has been populated with something.

View 14 Replies View Related

Insert A Comment Based On The Value Of A Cell

Jan 18, 2010

I have data validation and conditional formatting set for my sheets. However, I cannot figure out something.

I want a "comment" box (just as if I would click on "add comment") to pop up automatically if the user enters a certain value in a cell.

For example, if cell C4="1" then no further action is required. If cell C4=anything other than "1", then the user would be required to enter a comment. I would also like the comment to autopopulate with the users login id.

I will attach the book I am working on for reference, but I do not have any code written for this as I could not figure out where to start.

View 5 Replies View Related

Decision Based On Cell Comment

May 22, 2007

I would like to execute code based on the cell comment. If cell comment = "something" then do something. Is there a way to do this? Also is there a way to add aditional comment to the cell if one already exists? I am currently using this to write the comment

Selection.ClearComments
Selection.AddComment
Selection.Comment.Text Text:="New comment"

Obviously this clears the previous comment, I would like to just add more to it and retain the original comment as well.

View 2 Replies View Related

Cell Comments Line Breaks Based On Conditions

Jul 2, 2007

I manually enter data into inserted comments in a worksheet. Is it possible to run a macro that formats comments to align based on spaces? Ie

Entering "City","State" and "Amount" on row 1 in a comment and entering "Denver", "Colorado" and "5" in the second row would produce those words to align at a predetermined spacing (ie after every space the next word would start 10 characters over)
-----------------
City State Amount
Denver Colorado 5

View 4 Replies View Related

Conditional Formatting Based On Internal Cell Comment

Feb 19, 2013

Can I set the conditional formatting to highlight those cells, which contain internal (not pop-up) cell comment?

For example =10+N("free text comment"). The displayed value is 10, and I need this cell to be highlighted automatically.

The sheet has over 200 columns, so functions based on other cell values are not applicable.

View 8 Replies View Related

Setting Macros - Possible To Put Image In Comment Based On Value In Cell

Nov 12, 2012

Is it possible to put image in comment base on the value in cell ?

For example

c1 c2 c3
R1 A
R2 B
R3 C

I can put A.jpg to C1R1"A", B.jpg to C2R2 "B", and C.jpg to C3R3

Or irregular arrangement ??

View 9 Replies View Related

Excel 2007 :: Cutting Portion Of Cell Value To Cell Comments

Aug 9, 2012

I have an Excel 2007 workbook with several sheets, and various cells in several of the sheets have column headers with a description in the same cell enclosed in curly brackets, e.g. Header{Description}. I would like to to keep the column headers in their respective cells, but move (cut) the descriptions along with the brackets to the respective cell comments.

View 1 Replies View Related

Auto Generate A Comment Box Based On A Cell Value That Has Variable Reference Cells

Jan 30, 2010

I have been given the following code and it works great. I now need to adapt it to the following scenario: In the attached sheet, the user has to select either, "Suburban" or "Squad" in row 5. If the user selects, "Suburban" I need this script to compare the values they enter in a given row to the value in column "B".
If the user selects, "Squad" I need this script to compare the values they enter in a given row to the value in column "C".

Look at row 48, for example. If the user enters, "Suburban" in cell D5 then the value they enter in cell D48 should equal "1". If it does not equal "1" then it should proceed with the adding of a comment. Conversely, if the user enters, "Squad" in cell D5 then the value the enter in cell D48 should equal "2". If it does not equal "2" then it should proceed with the adding of a comment.

View 5 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

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

Cell Contents To Cell Comments With Lookups

Sep 18, 2009

I'm working on an attendance spreadsheet and would like to set up an onchange() macro that will do the following:

Take the contents of cell in column E, paste them as a comment in a cell found in sheet from F, row from C and column from today's date. Confused yet? this should help, my sheet has the following columns:

A Date
B Time
C Employee Name
D Callback number
E Reason for absence
F Manager

Spreadsheet has pages for each manager and I use the formula:

View 14 Replies View Related

Formula To Copy Comment From Cell A1 To Cell A2?

Aug 5, 2014

So I've got an Excel sheet with two cells - A1 and A2. In cell A1, I have a comment that says "Hello". Is there any formula I use to copy the comment from A1 and apply that comment to A2?

View 10 Replies View Related

Copy Cell Range To A Cell Comment

Jul 12, 2009

I have a recipe and a set of instructions on a worksheet in the cell range A1:H50 and would like to copy the whole range to a single cell as a Comment.

At the moment I select the range, copy and paste it to MS Word.

In Word, I select all and copy, then back in Excel, select cell, insert Comment then paste the text into the Comment box. Then I have to resize the Comments box. Also doing it this way loses some of the original formatting I could get round that by saving the cell range as a picture and inserting the picture in the Comments box.

Surely there has got to be a better way. Using 2007 Excel & Word

View 9 Replies View Related

Add Cell Data/Text To Cell Comment

Mar 24, 2005

attached excel file .I need the data thats there from B4:E8 to be displayed on cell I9 as a comment .is there any way to do it ?

View 6 Replies View Related







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