reference cell

My Workbook contains 2 worksheets: Sheet1 & Sheet2 In Sheet2: B2=Sheet1!T17 In C2 I want to get value of column A i.e. 'like' =Sheet1!A17...but I don't want to punch this formula. I need a reference formula with respect to cell B2. Thanks in adv.

Hi guys, Think this is a relatively simple fix, but have not come across the solution online yet, so apologies if I have missed something obvious! I am looking at labeling each variable in a loop. So we have a very basic table, such as : <code style="font-family: monospace, monospace; margin...

Hi, Could someone help with an excel query? I want to find the most recent date for each person and then choose the value two cells over for each ID? The following does not work as the MAX() range includes a mixture of dates and values: =HLOOKUP(MAX(A1,E1,I1),A1:L1,2,0) The database is...

Hi All I have been looking/trying various bits of code to insert a row on a large protected sheet. I have also been recoring various stages, but cant get the result I am after and think I might be overcomplicating metters. Large Excel sheet with A:Z and 1-100 hidden, full of calculations. The...

Hello, I've got myself a little stuck!! Any help would be very much appriciated! I am using excel 2003, Please see the linked example workbook below: https://app.box.com/s/wkv1yn5040t3wolorz8u I have a workbook with two sheets, the first is a random splattering of words and numbers the second...

In my Excel workbook, there are 2 ws: tab named "4" & "5" respectively. In 4: AA2='5'!Z13 Output required: in cell AJ2 : the value in cell D13 of ws "5" by using reference to the cell content of AA2. How to accomplish?

Hi, Using Excel 2010, Im trying to generate a formula to calculate a running subtotal from a data in a pivot table. I have a pivot that looks something like this: <TBODY> A B C D E F G H I J K L M N O 1 Column Labels Hours Days 2 Row Labels Jan Feb Mar Apr...

Hi everybody I'm new to the forum and kind of newbie with excel, and just for your information I have no knowledge of macro or VBA. I am trying to prepare a reporting for weekly sales, and I use many pivot tables in my calculations. Until now I have build formulas using getpivotdata function...

C2=K45 So C3 should be K46 & C4=K47. Formula needed in C3 & C4. Thanks in advance.

I have a dilemma and can't think of a simple solution, although I am sure there is one that I just can't see. If C5 refers to the value in cell C100, C6 refers to the value in C110 ten rows below. C7 refers to C120, ten rows below that and so on. Is there a formula that you use within excel...

Hello! I have a really unique excel task I couldn't figure out and hope for help here. I have a list of room types and their attributes (total area, furniture, etc). This sheet has a format that has to be kept, however to be able import the content to a different program I need a simplyfied...

Hello everyone. I am trying to manipulate an excel document so that I can import it into a flashcard system. To that end, my cells have to fit a specific structure-- A= [word ;(semi-colon delimiter)] / B=[" definition "]. To be more concrete, I must have a word with a semi colon in one column...

Originally I had a large sheet (named MASTER LIST) and an analysis sheet (named ANALYSIS). The Master List ended up with the million plus rows issue that I could not resolve. To address this problem, I copied and pasted into a new sheet (named LIST) my entered data plus a few thousands rows for...

Hello all, I'm looking for a formula that I can put in BA2 in a sheet called Data, and copy the formula down the column. If Data AE2 is blank, Data BA2 should be blank. If there is a number in AE2, the formula should look for the matching number in another sheet called Index, in Index column...

In Sheet2, A2=Sheet1!D4 Now how to get Sheet1!S38 in A3 (of Sheet2).?

This is a really ignorant question, because I should know the simple answer. I need a command that causes a selection over a range of cells where the column varies from one sheet to another. Here's what I've tried: ActiveCell.Offset(0, 0).Range("R[1]C[1]:R[2]C[" & LastCol & "]").Select I...

Hi I am confused as to which function would be best suited for the following situation. I have tried using vlookup, indirect, index, match and max with no success. I havent used excel since college in 2005. I have a feeling this is a fairly simple funtion but I have exhausted my brain digging...

Hi, I am try to do what I supposed to be a "normal" thing, but I am in truble! is there a way in excel to specify the reference of a cell in another sheet with a formula and not with fixed columns or rows? In the specific I have two sheets and I would like to link the cell using this...

Hello all, I'm trying to set up a formula that will populate all cells that are related to a single criteria. For example, I want to be able to enter a single store from a drop-down list and have all other stores from that store's district populated below or to the right of it in order to...

Hello, I have an issue where I need to change cell references in my formulas. I have hundreds of formulas like the following one: =IF(AND(Calcs!HQ54, Calcs!IB54=FALSE), VLOOKUP(Calcs!$EE54, $B$16:$R$50, 15, FALSE) + Calcs!DK54, Calcs!DE54) ) For all references to cells that are in the Calcs...