linking

What I would like to do is have the data auto-populate in the table based on the answers from the master table. Please see screenshots. Any assistance would be greatly appreciated!

Hi all, I am trying to link separate workbooks-not-worksheets that are yet to be created - these would be workbooks created in the future using templates, and the destination workbook I am working in will be a master template as well. This is for a project for study and I have really hit a...

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...

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.

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.

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

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...

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"...

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

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...

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...

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...

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

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...

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...

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

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...

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...

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

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...