reference cells

I know I have done this before but I can't remember how. I have an ActiveX control checkbox with the linked cell in G14. I need to write an IF statement in cell H14 based on if the result is TRUE or FALSE. If G14 = FALSE then H14 = 0 If G14 = TRUE then H14 = 1 Normally I would us the formula...

This is very hard to explain but here it goes. I have a spreadsheet A which columns B to J, Q and R from row 3 to 2000 are reference cells to another spreadsheet (in a separate file/workbook - spreadsheet B) are referenced from. In spreadsheet A, Columns K to P from rows 3 to 2000 are drop...

I'm scratching my head trying to see if this is doable and how. I have 2 worksheets (of many) in this project. The following is a super simplified version of problem. Sheet A is randomly sorted and is presented to the user as a logical grouping of ITEMs ITEM COST AGE apple 5,000...

I am trying to achieve the following through formula for a largish worksheet (100,000 rows) (Excel 2010), to identify 'Special' process against all rows which have both duplicate Job ID's and one 'Special' process included: <tbody> Job ID Process Associated Special Process? 45001 Process 9...

I have a workbook which has two copies of the same data (one in a hidden sheet). This is so that users can make changes to the data and it will track the changes. That works fine using an index formula but I also want to use conditional highlighting to show the cells which the user has changed...

Hello! I'm trying to work with some raw data and the data is organized in the following way: SHEET1 A name is in cell A8, with an Address on cell A9, a Telephone number on A10. SHEET2 I want to have a column in the second sheet called "NAMES" and under it, I reference the name on the other...

I’m creating a macro that will select multiple named ranges at one time. I’ve got it to work using “Application.Goto” but only when manually entering the named range title. Sub Appl_Goto() Application.Goto Reference:=Worksheets("Funding(4)").Range("MarPE,MarRW,MarCN"), Scroll:=True End Sub...

I'm helping a friend with a research project and I've met my match. She has roughly 1000 .txt files that contain data (when opened in excel) in A15:IV254, (yes, that's 61,440 data points per sheet!) and she is trying to a. find the max value in each file, b. find the cell location of that...

I am not Excel Savvy at all and have spent the better part of the weekend trying to learn/figure this out but have hit a wall. Work has tasked me with creating a spreadsheet that holds the records of 1000 or so employees and their regular tests. To achieve this I have created a manual entry...

I have the following code which operates as it should, taking a text string in the adjacent cell and converting it to a formula and applying it to a few other referenced cells. I currently only have about 20 rows of data but I anticipate having nearly 1,000. The run-time is already too...

Hi there, Excel 2013. My spreadsheet has 2 sheets. In sheet B I want to reference cells in sheet A using the ='Sales+Costs'!M16 syntax. So in sheet 2 Cell D77 is going to reference ='Sales+Costs'!M16. Thats fine for one cell but cell D78 then needs to reference ='Sales+Costs'!N16. Then D79 ref...

I am trying to pull a list of equipment from a tasking list that reference an equipment code. On a seperate tab I have input a count in Cell F6 with: =COUNTIF('CP Board'!B1:B1999,"*PS") and starting in A2 I am trying to use : =IF(ROWS(A$2:A2)>F$1," ",INDEX('CP Board'!B$1:B$2000, SMALL(...

HiI've a requirement, need to a return a value from an array of single row which fulfills the below condition:The formula or macro has to search for an entire selected range of a row and get the value of second cell from the first blank cell in the selected array of rows.Can anyone please help...

<tbody> Name number print stamp signed JDoe 157568 x x x Xcrod 489756 x x </tbody> So I want to highlight a range of cells within a specific row if every column within that row is filled with any text. What formula can I use? So in the above example, I would like the second...

Hello, I'm working on a spreadsheet that has a reference table with this information: <tbody> Part Process Employee Date Time Size Serial No: Carton Weight 10366/10367 L23 MFG 06/24/14 9:58:26AM 6 435 10366/10367 L23 MFG 02/17/14 8:57:38PM 6 436 </tbody> What I need help with is...

I have 2 tables: table 1 which contains a summary; table 2 which contains my data I want to be able to look up and sum the total of a column in table 2 based on the value in table 1 (ie. I need to be able to change the syntax in the formula "=SUM(table2[column])" To give an example, here is my...

So my problem is, i have a row of data, but due to cell merging and it's layout the cells i want are spaced 3 columns apart. I would like to be able to use the above cell's formula, but then add 3 onto the column number for the next cell. i.e. A1 formula = 'Worksheet1'!D2 I'd want A2 formula =...

Greetings, This might be a simple noob question but I cant seem to wrap my head around it. In column I3, I reference data on another worksheet. I want the formula format to shift to the right 3 columns each time. Here is the original info: I3='0152'!O3, I want to create a formula that will...

New member here, I hope you guys can help? I have a workbook called Contractor's Bid. The workbook consists of several worksheets with Tab names. To keep my question as simple as possible, I want to set a default profit margin on a sheet called "Admin". I can now reference the profit...

Hi I might be going about this the wrong way but here goes. I have a column of dates in A as the first column in a larger table of data. I have a summary of the data in a separate table which feeds into a chart. For example =PERCENTILE(D16:D6855,0.9). I want to set a start and end date by...