cell referecing

I am trying to use getpivotdata with a cell reference but get an error when adding the cell reference.

Hi! I've seen the solution most likely is the INDIRECT function but I am having a hard time getting it working. The formula in cell J14 is: ='IS, BS, CF Comb - mthly fcst'!CI205 This calling a value from another tab but if I want to create a chart at the bottom of this sheet where I would...

Hi, I am recieving a #VALUE ! error when trying to copy the result of a data validation drop down in another sheet and dont know why. e.g. In sheet 1 I have a a drop down box in a cell (A1) that has recent dates in. On sheet 2 I want the chosen date to show in a cell. I have put the formula...

I'm creating a table with calculated mortgage payments with principal (PPMT) and interest (IPMT) functions in adjacent columns. I want to be able to change the cell contents at the top of the column, e.g. PPMT to IPMT, and have the cells below it reflect the changed function. I've used CONCAT...

Hey Experts I need your help. I have to create a financial statements for set of years. We know that closing balance of particular year becomes opening balances of next year, so we link the closing balance of last year to opening balance of new year in new sheet. When we are done with creating...

Hi all, I have a large formula which currently looks into another workbook, part of which is as follows: [Project_Record_List_05.02.2016.xlsx]Customer Handling'!$B$15), the 'Customer Handling' is of course the title of the tab the formula is referencing in to but is also written in cell C2 in...

I have a worksheet (about 75x2770) each 'data-object' or row has a unique excel id. There are duplicates from how the data was loaded into excel - the excel ID allows me to easily find the duplicates. I would like to keep a row based on the contents of 2 independent cells (in the same row)...

Hello I Am Looking For VBA macro to create a table. The cell Address's though for the range of the table is bassed on the text in the cells. For Example A2 = "First Word" and D21 = "Second Word". I need a macro that will look up the cell address of each of those words and then create a table...

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

Ok so I regularly update files with hundreds of cell refrences to this workbook and different cells. Each year we recreate it and just update the year (i.e. from 2013 to 2014 as shown below. ='C:\Users\Me\Example\Issues\TEST123\Auto\2013\Fix\[How to 2013.xlsx]Tab1'!$A$1...

Hi Team, I'm in need of an excel formula or VBA Code that can assist me reference column of unique values (Column A) and have each of them duplicated in 11 rows of another column (Column B). For example: <TBODY> Column A Column B Apple Apple Orange Apple Mango Apple Apple Apple...

Hi, I have really been struggling with this and have no Idea what to do. Here is my formula: =IF(ISERROR(GETPIVOTDATA("Flavour Trend",UNFIFlavourTrend!$B$3,"Date","Mar")),0,GETPIVOTDATA("Flavour Trend",UNFIFlavourTrend!$B$3,"Date","Mar")) When I get new information I paste it in the sheet...

Hi everyone, Is there a formula that allows you to add to a cell reference but not to the related cell contents? So in cell C1 it displays "C10". In cell C2 I want it to display the reference displayed in C1 + 100, so it would display "C110". Hope that makes sense. Thanks in advance.... Pedro

For some reason when i enter a very simple Cell reference formula =Sheet1!C6 Excel is displaying the formula rather than the result. To confuse matters more, i could try a slightly different, but same function, formula in the cell above and it works fine. Can anyone please explain why this is...

I am trying to do something that I think should be fairly easy and perhaps I have even done in the past but can't figure out now what i'm missing. I just want to reference the cell in column D of the same row that I am working in, how do I do that?

Good Morning people! I need some help on something please, I need to do a copy cell reference, but if the cell is blank, i want the cell to remain blank, but every thing i try either just returns a 0 or false statement. EG. A1 has a entry in it, and I want B1 to show the same, so i...

Hi, In book1 and Data.xlsm i have sheets with same names and equal numbers of sheets. from book 1 i am settings cell referencing of book2 sheet1 A1:C200 for sheet1 A1:C200. which looks like this for now =IF([Data.xlsm]MayDat1!A1="","",[Data.xlsm]MayDat1!A1) here MayDat1 is the name of the...