cell reference

Hi, I have a pivot table that I can expand or collapse and an adjacent simple formula to calculate the difference between each row total and the grand total. i.e. =SUM(C6-$C$14) =SUM(C7-$C$14) What I want to do is to expand the pivot table and for the formula to still reference the last...

Hello Excel Professionals: I am trying to count each instance of a particular date within a text string. When I hard-wire the date into the formula, i.e...=COUNTIF(I:I,"*7/27/2017*") ...I get the count I'm looking for. My preference would be to use a cell reference for the date...

Greetings all. I have a list of data, where I need to count the number of replies based on certain criteria. It looks something like this: =countifs(Answers!$O:$O;J16;Answers!$C:$C;OR(C16;D16;E16);Answers!$M:$M;OR(F16;G16;H16)) (Please forgive any errors. I am translating from a danish...

hey Guys, so I am trying to automate this report using macros, and When I come to use vlookup, it puts the code as ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-12],References[#All],2,0)" This works for one of my sheets, but it wont work for all of them as new columns will be added with each update...

Hey! First time poster here - still getting used to VBA :) I'm currently having an issue shifting formula reference down one row for a more involved formula. Currently, what I am using works great for simpe formulas, but I can't get it to work for more complex formulas. Ex, I need to update...

I have a workbook that copies and moves on sheet to a new workbook and saves it to a selected destination. I have saved code into that sheet so that it carries over to the new workbook. I need to code so that It will assign the macro name to a shape in the workbook. So the code before editing...

Giving an example because its very hard to explain. IE: I have formulas that searches for employee names on sheet 1, A2:A15. All ten rows are locked with those formulas and formatted as "text". Some rows are blank and some have names in it. I am on sheet 2, and I want to transfer those the...

Hi all, I have another VBA question - I have a row of cells that from Column B to I that I need my macro to autofill down to the last cell that appears in column a. The issue is everytime I run the macro the last row will always change where it appears. Sometimes it could be row 10, sometimes...

I am totally frustrated by the fact that I have been using [=GETPIVOTDATA("Sum of Clicks",LinkedIn!$N$2,"Year",2016,"Month",September)] every month since January's data and it has been working but this month 'September' it cannot fetch the data from the Pivot Table even though the data is in...

Dear all I tried to create a code that will open a workbook. I don't want to use the exact file location, but instead, I want to work with a reference to a date in a particular cell. So e.g. I need to open a file called 'Test_20160630_V2'. Because I will need to do this every month, I don't...

Hi, Let's assume some data in A1 through A10. A1 through A5 contains one group of data and A6 through A10 another. I have referenced A1 in B1. When I copy/paste B1 to B2, I would like the cell reference to increment by 5 (to refer A6) instead of just 1. What would be the easiest way to achieve...

Hi all! I'm relatively new to more advanced Excel functions, so this question may be relatively easy to answer. I have a spreadsheet with a list of employees that is copy and pasted for every month of the year. As of now, the spreadsheet only goes through June. There are four columns, employee...

hello all, I have been using VBA to send emails out to a set email address and corresponding password, however I need to reference a cell so that it can be changed as needed. I'm hoping I just made a little error... This is the original: sTo = Right(sTo, Len(sTo) - 1) Gmail...

Basically i want to find the last row used (With Data In) and then use that number in a cell reference for data i want to copy over from a different work sheet. here is some of my code, I do realize that putting the x in the reference wont work but it shows what i want to achieve: 'Find the...

Hello Everyone, Each week, I create a spreadsheet, containing data and the file name is based on the week in question. With each spreadsheet, I have formulas linking back to the previous week to compare week over week. The formula looks as so: =SUM('T:\[STOCK, April 24 to April 30...

Hi All, I have formula as per below - it works fine. {=LARGE(IF(Departments=B2,Margin),B5)} I have the word "margin" in cell X1, when I replace it in the formula as follows: {=LARGE(IF(Departments=B2,X1),B5)} is does not work... Any help, greatly appreciated. Thanks - Mark.

Hi All, I've created some complicated macros that automate a lot of tedious work based on some spreadsheet. Now I'm on stuck on something I believe is quite simple? I have tried to google this and work on it myself but couldn't come up with a solution. Basically I need to create a macro that...

NombreHojanPos ="$0$31" right now but it changes, I want to paste =$0$31 into the cell d15 of my new sheet, so Whenever I change it on the original list, it will change here too. I can't seem to manage to insert this cell reference. I know it must be something easy, but I am a beginner and...

I have a sheet for each employee for example sheet2 is renamed JIM. In cell Sheet1 A2 I type Jim, in cell B2 I want a formula that will give me the data in cell JIM!B2. I tried =A2!B2 and =hyperlink(A2!B2) nothing works.

Hi all, Just joined and would be grateful for help with the following excel formula issue that I am running into. When using an array formula, is it possible to include cell references instead of actual words or numbers? If not, what is the best work-around to make the formula more dynamic, so...