reference cell workbook

Hi; I made a workbook which contained the data of equipment (A to AZ) available from a Facility with 6 additional columns which has the latest maintenance date that is inputted by the maintenance foreman. In which the next date maintenance should be done is shown how close it is and a color...

This is a relatively simple question but very hard to explain and therefore 'google', so I thought I'd ask here! Cells J6:209 are filled with already established references to other sheets. Each cell references a different sheet: J6: ='[Sheet2 - 7th May 2018 - Budget.xlsx]Summary'!$C$26 I...

First off, I am going to try to avoid using VBA due to other circumstances. This is how I am operating at the moment: I have 2 workbooks referencing cells off each other, my active workbook that I will be always using (let's call this Book 1) and my passive workbook (Book 2) that I would like...

Hello, I have one worksheet that is referencing the second. The second sheet has a column for each date and I want to know if a value was entered today on row 8 for example. If there is not a value, I want it to return blank, but if there is, I want it to display the value in a cell that gives...

I'm not sure how to word the question accurately so I have included some Pictures to aid me. Using Excel 2010 I am trying to copy data from one sheet, the "Form" to a database called "Master" but the data needs to go into a Row that corresponds with employee's pay numbers. This is the Form...

Hi, I'm new to posting on forums like this so bare with me as I try to explain what I'm attempting to accomplish. My company has a lab and we run different tests for different samples. I'm trying to find the total time the sample will take to run based on the tests selected. We currently have...

Hey people, I need help filling a series based on a referenced workbook. Here is my formula: =[CIF9000.xls]Sheet1!$A$1 I want to be able to fill down a series that only increments my referenced workbook. So, filling the series would look like this: =[CIF9000.xls]Sheet1!$A$1...

Hi, I am using excel 2010 with parallel virtual window on mac. I am getting a strange problem. If I open two workbooks by double clicking on icon, they don't recognize each other, meaning I can't refer a cell on one worksheet to a cell on another worksheet. I press "=" in a cell and activate...

Excel always finds a way to test my excelformulagenerating skills. This is a value from a cell =[Book1.xlsx]Sheet1!A1 which works by it self great. But I would need to pull sequential number from a column A:A full of numbers from 1 - 5000. So the cell would need to have formula of some sort...