Link Pop-up On Cell Select To Cell

Sep 24, 2007

I'm hoping to hover my mouse over a cell to display text as popup. This text is linked to a cell and is dynamic.

I'm only wanting this feature to display info (in the popup) not link to a website

Currently I've dodged my way around the issue by using a hyperlink for the sole purpose of taking advantage of its hover popup feature.

The problem is that a hyperlink popup is limited to 255 characters so i can't display much text.

Is there is any VBA code or add-in's that take advantage of the mouse cursor position to display a text popup?

Kind of like the Comment feature but for dynamic use.

ADVERTISEMENT

Formula That Uses Link In A Cell To Create Offset Link

Jun 28, 2013

I have two worksheets, one with detail monthly information and one with YTD information. So let's say the three numbers I want to capture in the YTD sheet are in columns B, G and I on the monthly sheet. January's data might be in B5, G5 and I5. February's data is in B12, G12 and I12 and so on.

On the YTD sheet in cell C2 I link to Monthly!B5 and in C3 I link to Monthly!B12 so cells C2 to C13 on the YTD sheet show the monthly totals from column B on the detail sheet. On the YTD sheet, cells C20 to C31 show the monthly totals from column G on the monthly sheet, so cells G5, G12, etc. And finally, cells C40 to C51 on the YTD sheet show monthly totals form column I on the monthly sheet.

In the past I've always created all these links manually. After creating the links in C2 to C13 on the YTD sheet, is there a way to use a formula in C21 that uses the link in C2 to create a link for G5?

View 6 Replies View Related

Copy Or Link Formatting From Conditionally Formatted Cell To Another Cell?

Aug 12, 2014

I have a column who's content is determined via about 6 nested if statements from data on that row. That cell is then conditionally formatted to a certain color based on the text that is ultimately printed from the nested ifs (simply an extra visual legend for the text). All of this contributing info and about 1000 lines items make a very large and difficult to print page. What I am trying to do is a make a summary sheet that simply takes the index number of these 1000 rows and copies or links the conditional formatting of the mentioned cell onto this number on another sheet. I have already linked this status cell and put it adjacent to the index number which works well in that with two columns I can show the index and status but if I could combine the color of the status cell onto the index cell, it would be even better. I am pretty sure another conditional format for this summary sheet would not be possible or be extremely complex since the contents of the index cell I am conditionally formatting have no bearing on the conditions for the format. Was hoping there is some VBA magic that could simply mimic the conditional formatting from one cell and put it on another.

View 1 Replies View Related

Macro To Link Cell To Sheet & Cell Stated By User

Jun 3, 2008

I have a macro that inputs a sheet and cell from the user. when the macro tries to make a formula it outputs =data!'AE3'. I need it to output =data!AE3

Dim Sheet As String
Sheet = InputBox("Take Data from where?")
Dim startcell As String
startcell = InputBox("Start Cell?")

ActiveCell.FormulaR1C1 = "=" & Sheet & "!" & startcell & ""

View 3 Replies View Related

Link A Cell To Another Cell On Same Worksheet Using A Formula

Jan 13, 2010

Is it possible to link a cell e.g. A10 that has a time value in it (there is a formula in this cell that puts in the time value) to another cell in a range of cells e.g. B1:B1000 that has the same time value?

I know someone out there knows how to do this.

View 9 Replies View Related

Link A Certain Words In A Cell With Another Cell

Sep 16, 2009

For example, Cell A1 = July 2009 Cell B1 = July 2009 MTD. how to change 'July 2009' in cell B1 automatically in respond to the changes in cell A1.

View 5 Replies View Related

How To Link Format Of A Cell To Another Cell Along With The Value

Apr 19, 2013

I am working on a file with multiple tabs. I have an output sheet which brings values from different tabs on to the output.

I am bringing the values using a simple VLOOKUP.

What I would like is to bring to the output sheet not only the value from the inner sheets, but also the cell color.

The cells are not colored using any logic or using conditional formatting, otherwise i would use the same logic or put the same conditional formatting for the output. The cells are colored by the users arbitrarily.

For Example, please refer the sample file. In this file, when I select Company A, the values are from the tab Company A, but the cell colors should also be the same as in COmpany A. When i select Company B, along with values, the cell colors should also change as per what is on the tab company B. Is this possible?

View 2 Replies View Related

Link To Cell Instead Of Getting Cell Data

Aug 5, 2008

I want to create a summary page with the tab name and a link to the contents in a specific cell. In the code below, I can get the sheet I want but in the second column, I would like to link to the data instead of getting the data in the cell. Can I do this with a simple modification to this

Dim a As Long
Sheets.Add.Name = "Notes"
For a = 1 To Sheets.Count
Worksheets("Notes").Cells(a, 1) = Worksheets(a).Name
'The next line gets me data, but I want to link to this cell in all worksheets
Worksheets("Notes").Cells(a, 2) = Worksheets(a).Cells(15, 18)
Next a

View 9 Replies View Related

Range Select Statement To Select A Cell

Jul 7, 2008

I want to put a range select statement to select a cell and count down 10 cells and copy.

View 9 Replies View Related

Find Certain Cell That Contains Today Date - Select Cell And Its Sheet

May 8, 2014

I have made the macro that does as ,soon as i open the file, select today's date but only if date is in sheet5... sheet 5 is may so it works. Doing the same job for every sheet in the file.

View 10 Replies View Related

Excel 2010 :: Select Range From Given Cell And To Last Row And Column Of That Cell?

Oct 2, 2012

I am using 2010 and want to select a range starting at the same cell all of the time (regardless of whether or not it has contents - so let's say B7. Starting at B7, I want the range to include all of the columns starting at B and go to the end of all of the columns. Then I want the range to include all of the rows starting at B7 and end at the last row. I will eventually copy this range and paste it on another worksheet start on a specific cell of another worksheet. (Perhaps, we can add a name to this range).

View 2 Replies View Related

Highlights Multiple Rows If Select Cell (formula Cell)

Oct 3, 2013

I have a matrix with numbers that each cell is composed by a function of two parameters (two columns). The formula is

"=COUNTIFS(T2:T99,"15",V2:V99,"14")",

So it's counts when in one cell column I receive 15 and in the other 14. For instance, I receive the number 3 - so I have three rows that match (the first column with 15 and the second with 14).

I want, when I select the cell from the matrix (table) with the number 3 (that I receive from the formula) it will highlight the relevant rows..

View 3 Replies View Related

Link To Another Cell

Nov 17, 2008

I would like to have a link in a merged set of cells that puts the insertion point to another cell. Scenario: In cell k30, the user puts in the amount of credit card debt a individual has, and scripts the user based on that information. Later on, they get a more accurate running total of the amount of debt and need to change the amount in k30 for an accurate quote. After ther running total, in cell j172(a merged box for instructions) i instruct the user to be sure to enter the new total in cell K30.

Questions:
1. Is there a way to put a button or a link that would put the insertion point back up to K30 automatically, but allow the user to change it themselves and not change it automatically?

View 2 Replies View Related

Link To Any Cell

Aug 27, 2009

I would like to ask if there's a way that i can create a link in a cell to another cell. Sample: in cell A1: there's a word "click to go to cell A150" in this case i dont have to use scroll down to go to cell A150.

View 2 Replies View Related

Link Cell Value (last Four Of SSN) To Folder

Apr 29, 2014

I have a column on a spreadsheet containing the last four (XXXX) or in some cases six (XX-XXXX) if there are duplicates of the last four SSN. I manually enter these as needed. I also create a folder that will be named the last four or six in the same format that is in the excel spreadsheet. Is there a simple way to automate the linking of these cells to the external folders?

View 3 Replies View Related

VBA To Link Cell Between Different Sheets?

Mar 12, 2014

I have a macro that copies a sheet and renames it:

Copies "Q114" and renames it to "Q214".
Q114 is defined as OLD in my VBA code
Q214 is defined as NEW in my VBA code.

I also have a third sheet, call it "results", which picks up cell values, ie cell A1 in "Q114", but now I want it to use cell A1 "Q214". The values hasn't been filled in, so I need a link between them:

[Code] ......

View 2 Replies View Related

Possible To Link The Name Of A Tab To A Cell In Its Corresponding Worksheet

Nov 3, 2006

if it is possible to link the name of a tab to a cell in its corresponding worksheet.

View 9 Replies View Related

Use A Cell Value In A Address Link...

Mar 9, 2009

I have is a summary worksheet with two columns. One column is for Project ID number and the other is an address link to a specific cell in the worksheet corresponding to the Project ID. Perhaps the best way to explain this is by giving an example:

Project ID (Column 1)
00-111

Balance (Column 2)
='C:Financial Sheets[00-111.xlsx]Phase_21'!$H$1

As you can see the spreadsheets are named after the Project ID number. What I would like to do, if possible, is instead of typing in the name of the spreadsheet for each project in column 2 (Balance), I could somehow reference the cell value in column 1 (Project ID). Something like this:

Project ID (Column 1)
00-111

Balance (Column 2)
='C:Financial Sheets["A2".xlsx]Phase_21'!$H$1..........

View 3 Replies View Related

Link Cell To Sheet Tab

Jan 25, 2010

Can you link a cell to a sheet tab. If yes how?

View 4 Replies View Related

Link To Another Cell Not Working?

Oct 6, 2011

When I use the following link it works perfect

='W:APMProdqtyElectronic Shift Book8882Line 1[wk 40.xls] Flipchart'!$B$36

But when i replace Drive W to the full server location

='iemafs001APMProdqtyElectronic Shift Book8882Line 1[wk 40.xls] Flipchart'!$B$36
I get #REF!

View 1 Replies View Related

Link Sheet Name To A Cell

Dec 4, 2012

Is it possible to link a sheetname?

I have a list of employees on sheet1 and each employee has there own sheet with their name as the sheet name. Each sheet contains a form that the employees need to fill in.

I have created several extra sheets for new employees and I would like these sheet names to be linked to a cell on sheet1. This way the only updating I need to do when receiving new employees is enter there name to the list in sheet1.

View 7 Replies View Related

Link Dependent Of A Cell?

Jan 28, 2014

In Excel it's possible to create a link dependent of a cell.

Example

='C:UsersAMDesktop[" & C9 & "]Sheet1'!$B$3

where C9=Andrew.xls

View 7 Replies View Related

Get Cell Link As Text

Feb 20, 2014

I am trying to convert a formula that refers to another workbook as text.

E.g. in cell A1 the formula is "= '[Management Pack for January 2014.xlsx]Monthly Income Statement'!$G$23"

How do I in cell A2 show the reference "'[Management Pack for January 2014.xlsx]Monthly Income Statement'!$G$23" as Text?

The above formula changes the whole time.

View 2 Replies View Related

Link Data In 1 Cell

Jul 25, 2008

Sample data:

Machine Part Number machine 1 123 machine 2 123 machine 3 123 machine 1 123 machine 2 456 machine 1 456 machine 3 456

i need to based on tis sample data come out with sth like tt:

Used In: 123 Machine 1, Machine 2, Machine 3 456 Machine 2, Machine 1, Machine 3

I need to group those machines under 1 part number. For instance, part 123 is used in which machines, I need to state them in a way like above. But repeated should not be stated again.

View 9 Replies View Related

Link Image To Cell

Apr 10, 2009

In Excel, I have a sheet for each team that I manage. Each sheet lists the team members and displays their picture below their names. Some people are on multiple teams/sheets.

I have a master list with everybody's name and picture that I copy and paste the pictures from when putting a team together. This has become a very tedious process.

Is there a way I can type the person's name on a team sheet and have their picture automatically appear below their name? I don't know if this can be done with some kind of lookup or if it will involve VB. I tried making the picture the background of an Autoshape or comment, but I could not figure out how to dynamically change the picture based on the name in a cell.

View 9 Replies View Related

Link Tab Name To A Cell Without Using A Macro

Aug 17, 2009

Is there a way of embedding a formula in a worksheet so that the tab name of each worksheet is linked to a value in a cell on that sheet? (I don't want to run a macro)
In other words if the cell name is changed, the page name changes automatically.

View 9 Replies View Related

Find Which Cell Contain Link

Jun 8, 2006

I have a file contain some links with the other file. I want to remove these links but I don't know which cell contain the links. Is there anyway that can let me know which cell contains links so i needn't search one by one?

View 4 Replies View Related

Link Cell Formats

Dec 1, 2006

Is there a way for your linked data to cary over formatting such as Bolds, borders, fonts and colors?

View 3 Replies View Related

Lookup Cell Fed Via A DDE Link

Sep 12, 2007

I am trying to build a stock watchlist in excel 2007 with a dynamic link to a DDE server (paid for).There is no add-in or plug-in, I just CTL ALT & drag each code from a watchlist in the program I am using and place it in a cell, however can only choose one data field at a time. There are 14 data fields and over 150 codes in my list which makes 2100 cells. (My guess is about 3 days work)

I would like to just enter the stock code in say column A (A3) and with each DDE data field (e.g. lastprice, open, cose, high etc) entered in subsequent columns have it lookup the stock code in cell A3 and return the correct value based on the code in column A, rather than entering each cell individually.

Is it possible to write a macro or vba code to create the cell formula so I can just fill down and save myself 3 days work?

The DDE server I am using is formatted like this:

PROGRAMNAMElDATAFIELD!STOCKCODE

example

MISDATAlLASTPRICE!BHP.ASX

I thought I might be able to do something like the following, but it doesn't seem to work.

MISDATAlLASTPRICE!$A3

Note: The DDE server can only be accessed while the other program is running and is password protected

View 7 Replies View Related

Change Cell Colour When Select Cell

Oct 26, 2009

I have VBA code that changes the cell background colour in column A based on criteria in column B. What i want to do is select a cell in the same row in a range column O:AB and change the background colour to the same as column A. This action is for rows 4 to 41.

Basically i just want to click in a cell and for that cell's background colour to change and match the colour in column A.

View 9 Replies View Related

Cell Link In List Box Properties?

Jul 24, 2012

I'm trying to get a multi-selected list box to populate cell A2 with a concatenated list of what is selected; cell link works for single selections only? Is there any code, vba or function that can accomplish this?

View 7 Replies View Related

Link Cell Contents Across Worksheets?

Feb 28, 2009

I work for an IT company who build their own PC's. And we use a simple Excel 2003 spreadsheet to piece-together and price-up PC's for retail, I've attached an example of the spreadsheet for you to see. It uses basic formulas so we can see at-a-glance things like VAT figures, margin, profit etc. Each PC we sell is contained within one Excel file, and each PC has it's own Workbook tab.

The problem I want to solve is whenever we change a component or price, we have to do each system manually, which gets very repetetive and time consuming. What I'd like to be able to do is change the price of, let's say, the motherboard, and have the price be reflected across each of the PC's using that same motherboard on each seperate tab. This same system would apply when we change a product name, product ID etc.

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

How To Link A Cell To The Next Worksheet In Line

Oct 31, 2013

Is there a way to link a cell to the next worksheet in line and not to a specific worksheet?

I have a summary worksheet that needs revolving values, based on the 5 most current worksheets (all of which are identical).

View 2 Replies View Related

Link Auto-filter To Different Cell?

Jan 23, 2014

How can we program an auto filter a table linked to a cell. For example I have a table with 4 columns (A9:D20) and the 2nd row of the sheet is the filter item (A2, B2, C2 & D2).

Lets say column A has a list of months, column B has a list of names, column C is sales figure, column D is the customer. How can I filter let say for the total sales of Mr. X in the month of January.

I came across a code like this but I don't know how to apply it to my sheet. Of course this code is referring to a different table and links but I just need to learn how to apply this code to my sheet:

Activesheet.AutoFilterMode = False
Activesheet.Range("D2:D60").AutoFilter 1, Activesheet.Range("A2").value
AutoFilter.xlsx

View 4 Replies View Related

Spin Button Link To Another Cell

Feb 23, 2008

how to linked the "small change" value in a spin button to take the value of another cell?

View 12 Replies View Related

Link To A Cell From A Commandbar Control

Apr 28, 2009

I have a right click event for a cell where I create a custom commandbar with single or multiple control buttons based on the cell value. I want to link each control button to another cell in the same sheet.

View 2 Replies View Related

Read Data From Web By Using Link From Cell?

Aug 1, 2009

Iit is possible to do somethiling like this? I wanna load some data from web but I need link read from cell (e.g. sheet data!B1) .. so it means :

View 3 Replies View Related

Automatically Generate The Link Cell

Nov 10, 2009

A1, B1, C1, D1, E1, I1, J1 & D3 all linked to L1 thru S1 perspectively But when I copy the highted box and paste it, A4 automatically link to L4, as well as other fields. create a macro where excel automatically generate the link A1 = L1, A4 = L2, A7 = L3 and other fields perspectively all the way til the end?

View 3 Replies View Related

Link To Specific Cell In Preceeding Row!

Sep 29, 2008

This time I need to be able to reference a specific cell in the preceeding row of a GETPIVOTDATA formula. This is shortened example but it shows what I am trying to achieve:

A B C
NAME ID FRQ
Spellbound 1234 W
Spellbound 1234 W
Spellbound 1234 W

The GETPIVOTDATA formula is located in C6 in this example and needs to reference B5 i.e. the last ID cell reference. I need to work the formula this way as it will be placed at varying intervals in column C and the preceeding data for each NAME will vary as to how many rows each NAME contains.

View 2 Replies View Related

Cell References Inside A LINK

Oct 2, 2008

is it possible inside this link to put a variable reference? for example to have a cell in my excel which in this case would be Report FY09 and if i change it to Repot FY08 the link would be c:Report FY08[PPV REVENUES FY 09 - Actual.xls]PPV Actual'!$C$4:$BB$4 or in another case if i have the name of the sheet like

='Report FY09'!D4
to do it
='Report FY08'!D4

or even the excel file
c:Report FY08[PPV REVENUES FY 09 - Actual.xls]PPV Actual'!$C$4:$BB$4
to do it
c:Report FY08[PPV REVENUES FY 08 - Actual.xls]PPV Actual'!$C$4:$BB$4

View 4 Replies View Related

ADVERTISEMENT