link cells

  1. H

    Hyperlink cell based on value

    I am having a sheet in which I want to hyperlink a cell such that it finds text mentioned in formula and moves cursor there For this I am using below formula =HYPERLINK("#ToDo!A" & MATCH("promc1",A:A,0), "display text") Above formula is entered in cell A53 Todo is sheet name in the same...
  2. C

    Assigning column values to a heading

    Hi, Yesterday I posted a similar question to this one but figured more context is needed in order for a solution to work for me :( For context, I have data in a primary table structured like below: <tbody> Name City Level Jeff Perth 5 Mark London 2 Phil New York 4 </tbody> The names...
  3. C

    Assign column values to heading? - Linking Cell Movement

    Hi! I want to be able to make cells move together if I change the value of one of the headings. I currently have the heading set up to come from another sheet using a vlookup. When I insert a column on the other sheet, (say, Jim) the second table below is what I get, but what I want to occur is...
  4. K

    Link Cells to Change Cell Value from Many Cells

    I don't actually know how to word this question. I'm not looking to simply link cells together with an = or similar function. Is there a way to set up cells so that if I change the value in any of those cells, they all change? Ideally, they will link across sheets. Example: A1, B2, and C3 are...
  5. V

    Number Formats, Decimals And Linked Cells

    Hi All, As a basic user, I'm having what I hope is an easy to answer issue, so apologies if it's been asked before. I have a spreadsheet which records scores for a charity quiz I run twice a year. The scores are entered into Sheet A (which is organised alphabetically by team name for ease of...
  6. K

    Formula to replace CountIf with a ">0" criteria

    Right now I have a Summary workbook (let's call it [Summary.xlsx]) which has links to about 60 other excel documents (I'll refer to as [Other.xlsx]). I'm trying to pull the last number in a column from the [Other.xlsx] documents into a cell on the summary workbook, but the [Other.xlsx] is...
  7. C

    Copy worksheet to new workbook with everything linked

    I want to copy a worksheet to another workbook where everything is linked. For ex: I have a workbook called "Budget 2016" with a worksheet called "Credit Cards" and a worksheet called "Budget IL & FL". In the "Credit Cards" worksheet I have all info about each credit card like the balance...
  8. N

    Automatically Change String Value of a Cell Based on the String Value of Another Cell

    Hi Forum, I've had a tough time searching for a solution with Google. I don't quite know how else to phrase it. I have an Excel workbook where users input data. In two of the columns, D and E, users select from in-cell dropdowns (data validation). Each column has three selections to choose...
  9. M

    Link excel to PDF

    Is it possible to set a print area in an excel sheet that would hyperlink to a Bluebeam PDF document such that anytime changes were made in the excel those changes would appear in the PDF? In addition a change to the excel sheet might be a different, usually larger, size of print area. I assume...
  10. K

    Link values between 2 cells, same row different columns

    Hello All, I have a sheet that has a list of sheet names that "live" updates, when a new sheet is added or a sheet is moved in the workbook the list updates accordingly to keep the order the sheets are in. However, the column next to that list of names allows the user to place an "x" in cell...
  11. M

    autofill and autocopy of cells from other worksheets

    Hey everyone, Can anyone please tell me how to do this? Just bear with me until I explain what I need to do. Thanks and... here we go! :) I have 1 MAIN worksheet that is named TOTALS and 12 secondary worksheets (one for each month of the year) that are called.... January, February, etc. Now...
  12. E

    Link cell data, hyperlinks, and formatting from Workbook 1 to Workbook 2 in Excel 2013

    I need to create a workbook, called “Roundup.xslm,” that links back to cells in the primary workbook, “Articles.xlsm.” Each record (row) has six columns (A:F). One of the columns is hyperlinked to a file or Web URL. I need to link the rows in Roundup to the records in Articles so that when the...
  13. L

    Click on a cell to link to a cell on a different sheet with same string

    With Exel 2003: Sheet 1 <TBODY> A B C </TBODY> Sheet 2 <TBODY> C B A </TBODY> I want to be able to click on a cell in sheet 1 and get linked directly to a cell with the exact same string in sheet 2. I have just been asked to do this for my boss and I havent...
  14. K

    How to link cells to each other by 2-way dynamic link?

    Hello, I want to link 2 cells to each other so that the user can enter a value in either cell, and the value is automatically copied to the other cell via a 2-way dynamic link. Is there any way to set this up without using VBA? I would be surprised if Excel does not have this capability, but...
  15. F

    Date and Number Linked to a Conditional Formula

    I want to have a cell that contains a numeric value that's connected somehow to a date. Is there a way to make a cell that contains a value to be "date specific". Here's what I'm trying to do. I'm making a sheet that is helping me determine inventory quantities at the beginning of each...
  16. 9

    How do you lock, link, or associate a single row of data so it stays together during a sort on another worksheet?

    I have a spreadsheet in which Worksheet 1 is a master list of names andgroup assignments. Worksheet 2 sorts these names into the respective groups. Worksheets 3 and 4 are group specific worksheets, pulling the sorted group lists from worksheet 2 into column A. Attendance Data for each...
  17. H

    linking cells

    How do i link cells ie if i input somethng into say e5 I want it to add 1 to d5 then if i put info into e6 it will add another 1 to d5 making d5 =2 so E5 =lost18 e6 =won 18 then d5 would =2 e7 =won 9 then d5 would =3 but e5 is on 1 sheet2 and d5 is sheet 2 but in same workbook
  18. S

    Linking to other worksheets and replacing

    Hi, I have a master workbook that contains links to a bunch of other workbooks. Primarily, I am just linking to the data themselves, which are numeric. My links currently look like =[source_file.xls]sheetname!A5 I would like to do a few different things here: 1) incorporate replacing in this...
  19. B

    Excel Cell links

    Hi guys, I need some help linking two cells in the same work sheet. I want to be able to click on a cell and it take the viewer to the related cell elsewhere in the spreadsheet... I can do this with a hyperlink but my issue comes when I move the linked cell to a new location. The link then goes...
  20. B

    Dropdown List

    I am trying to create a dropdown list that when an item is selected in the dropdown, the cells to the right autofill with data related to that selected item. For example. If I click on a dropdown and choose "Wednesday" in Cell A, then in Cell B, C, and D, autofill with "work", "gym", and...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top