linking

  1. T

    please help with vba coding

    Ok, so what i am trying to do is to use a vb form to view ranges on a worksheet. i dont want to change anythin but i do want to scroll through to the last row that has data. that being said, i have literally tried everything i can think of short of just writing a java script and doing what i...
  2. B

    Linking worksheets

    I'm attempting to link worksheets using ='worksheetname'$A$1. I'm getting that reference in the cell I'm linking and not the actual value in the cell I'm attempting to link. Thoughts please.
  3. M

    Linking to another worksheet cell content in a cell formuka

    Hoping that is not too confusing!! Take a cell formula eg =if(VLOOKUP(A1,'C:\[Foo.xls]Sheet1'!R4C1="99","1","0") I would like to store the worksheet reference - C:\[Foo.xls]Sheet1 - in another workbook. I cannot work out how to write the Vlookup using such a link.
  4. D

    Changing linking so instead of being between tables, it is linking between ranges

    I started a thread that had a bad name so I started a new thread with a more meaningful name. The original thread is here https://www.mrexcel.com/forum/excel-questions/1098809-i-need-some-help-please.html#post5283211
  5. H

    Excel linking cells

    Hi guys, I am making a worksheet and have a question regarding linking cells. What I want to achieve: Having two cells (on different sheets or not) which contain the same text. So if I change the text in one cell it also changes in the other cell. Vice versa. I've tried doing it just like...
  6. I

    Advanced linking of workbook to another workbook

    I hope I explained what I need here. So this is how it goes. 1. On Workbook A, I have a cell B4 - B7. The values are populated from Workbook B - sheetname "Fruits", cell C4 - C7 2. On workbook A again, I have cell B11 - B13. The values are populated from Workbook C - sheetname "Vegatables"...
  7. B

    Linking Two Spreadsheets

    Hello to all, need help getting a 0 to go away when linking a excel spreadsheet to another spreadsheet.
  8. E

    Summary Tab of Multiple Sheets

    I have to create a summary sheet of approximately 60 worksheets. Luckily all of the worksheets are the same format so when I do the summary tab I am linking the same cell across all the worksheets. Are there was of linking the cells to the summary tab without having to go to each cell on a tab...
  9. Y

    moving contents from 1 sheet to another in a different format

    thank you for looking at this post! i am very new to excel, i didnt even know some things were possible that i have read here. i am looking for guidance i get data in a spread sheet and make it easy to understand for others. this how i receive the data...
  10. D

    Linking Two Variables to give value in different cell

    Hello, Please could you kindly assist, I have an excel summary doc, which i am trying to prepare. The requirements are for me to provide a summary page of Raw data in a vertical way as appose to current data that is horizontally... I am trying my level best to take two variables "Store...
  11. L

    Linking sheets with equations

    Hi I am reading excel course outline and I read the following: Linking sheets with equations Linking files with equations What does that mean? how to link sheet/file with an equation? Thank you so much. Course outline is here http://www.ctccomputertraining.com/excel2010trainingcourses2.html
  12. E

    Linking Multiple Workbooks

    We are working on a budget program, where department managers can input data into a single sheet that will then link into a larger workbook. Within these input sheets, we would like to copy data from another workbook to display reference data. And when we try to do so, we are getting the...
  13. E

    Linking multiple sheets

    We are working on a budget program, where department managers can input data into a single sheet that will then link into a larger workbook. Within these input sheets, we would like to copy data from another workbook to display reference data. And when we try to do so, we are getting the...
  14. A

    Linking Worksheets

    Is there a way to link worksheets together, to where I modify one and the other updates? Thank you,
  15. K

    Linking to a website

    I have a workbook containing data referring to the progress of my shares which is linked to a website which contains a table of historical data relating to the closing price of the shares. Unfortunately the web page does not remain static which means that the formulas in my spreadsheet do not...
  16. D

    REF issue when linking Workbooks but only in certain tabs

    Hi I have 2 source workbooks being created by a system, alongside 2 templates, A and B. A reads directly from the source file 1, with some additional basic calculations. B reads some data from the source file 2 and the results of the calcs in A. My issue comes with Workbook A, which has 3 tabs...
  17. U

    Linking Formulas To Another File

    I would like to create a master template that I can change that automatically filters to down-line files . This is easily done via linking with static data but I can't figure out how to do it with formulas. Is there a way? Thanks in advance, Tyler
  18. S

    Drop Down Lists linking to sources

    Hi Can someone please help? I would like to set up the following, can someone please tell me how I can do this? I have a drop down list consisting of 5 values, Level 1, Level 2, Level 3, Level 4, and Level 5. When I choose Level 1 in the drop down box I want it to open a table in the worksheet...
  19. P

    Excel- displaying linked images based on filepath

    I need to have Excel display images based on the file paths from another column. In a certain way: column G shows the name of the folder column H shows the name of the file(usually: 00, 01, 02, ...) column I specifies the filetype ONLY if it is different from .jpg The image should appear in...
  20. U

    Linking Excel 2016 Workbooks

    OK this is a three part tricky problem. After reading some useful online information about linking Excel 2016 workbooks I decided to try it in an effort to ensure data consistency and reduce the amount of time it took to update nearly 100 workbooks with relevant foreign exchange rates data...

Some videos you may like

This Week's Hot Topics

Top