cell reference

I have Column A that references another column on another tab. So I have cell A10 referencing W2 on tab 2. I want column A to change automatically when Column W on tab 2 changes (i.e.- a row is deleted) and not display any errors such as #REF . I understand why it does that, but I don't know...

Hello - i have an excel file that has numerous tabs. Each have a name, what i am trying to do is in the main sheet, enter in the tab name so that the info that is copied will paste to the correct tab. see code below - i get an error on the top line. The Tab will change each time i go into the...

Hi, I am a beginner at excel. A number of months ago I created an excel file, used for sorting quantity data. The first sheet is used for importing (pasting) the raw data. This raw data is then sorted into other sheets depending on the "Product Type" column. I have since introduced two new...

I thought this was straightforward but it does not seem to be. I have a two spreadsheets and in one (call it S1) I get a calculated value in column C. In the other (call it S2), I want to link to the values in column C. If, in S2 B10, there is a reference =S1!C10, and I sort S1, how do I...

I have an interesting one here. I'm looking to try and substitute the text from a cell into the measures portion of a CubeValue formula in Excel. The CubeValue references data from a related sheet in PowerPivot and I'm bringing over multiple columns of numbers so it would make life easier if I...

In case possible, how do I make a cell's value reflect in another cell and have the capability to edit the value on either cell? For example, I have cell A1 in Sheet 1 and A2 in Sheet 2. I want it that when I put "Pass" as the value for 'Sheet1'!A1, the same value appears in 'Sheet2'!A2...

Hi Folks, I am assessing the values of several thousand data sheets. So far, I am running a macro to conditionally highlight cells of specific values, then writing down the table location. I am trying to expedite the process by getting Excel to list the cell names for me. I named each cell...

Hello there! 　 I have pieced together several macros and I am almost good to go with my project. However, the macro I need help with is the actual sending the mail. The script I found, would generate a pop up and could use that to enter in an email address. However, I'd like to remove the pop up...

Hi guys, I need to figure out a way to enter a cell reference in every nth cell. Is there a macro or cell reference function I could use for this? Example: cell AA is referenced in cell BB, cell AB is referenced in cell B4, cell AC is referenced in B6.... and so on. I want to reference the...

Hi guys! I'm having some trouble with what I thought should be a pretty easy macro. I'm constantly working in a big workbook with many tabs. I want to be able to easily save a copy of the worksheet I am currently in and for the file to be named based off a cell reference. This code works when...

Hi, I needed some help writing VBA. I need to reference a range of cells one by one from sheet 1 (cells are in the range A2:A2357) to every 4th cell of column D in sheet 2, starting at D2. Please let me know how I can solve this. Thank you in advance for your help.

Hi! I wonder if anyone can help me understand this in my opinion very strange VBA behavior (or if I miss something obvious). I have a Macro where I check if the content in an Excel cell can be interpreted as a cell reference. If so I do something if not I do something Else. A simple test...

I have a workbook that I use to track attendance for meetings, training's and a few specific duties. I have a worksheet for each individual I track where I put the totals each month. I have another sheet that references each individual sheet to give me a good overall view for all individuals...

Hello! I'm working with the following section of a formula: SUM(SUMIFS('All Facilities'!$AC:$AC,'All Facilities'!$F:$F,$C$29,'All Facilities'!$AR:$AR,{"Operating","2017*"})) It's working just fine (and yes, entered with ctrl+shift+enter), but I want to make an adjustment to it: That last part...

Hi all I have scoured Google (including this site) and can't find the answer to this - there have been solutions given to other people that just don't work for me. I have this formula: =GETPIVOTDATA("[Measures].[Sum of Actuals]",'2017 Calc'!$A$3,"[Range 1].[Order Date (Month)]","[Range...

Hi, I am attempting to create a table where costs can be calculated by the user. These are spread into different categories. I have created a macro using relative reference and assigned this to a button which allows a new line to be entered into the table every time the button is pressed but...

Hi MrExcel Community, It's my first post here - so "Hello" :-) Currently I'm using this Audit Trail Macro to track cell changes in multiple sheets: Option Explicit Dim sOldAddress As String Dim vOldValue As Variant Dim sOldFormula As String Private Sub Workbook_TrackChange(Cancel As...

Hi, I have acquired two set of datasets with Time versus Data; T1 vs D1 and T2 vs D2 T1,T2 is timestamps in hh:mm:ss.00 and D1,D2 is data in Numbers format. T1 and T2 intervals are different, while the T1 has ~1second interval, T2 has ~100 millisecond interval. However the overall time period...

Good evening. Could you please assist me in calculating the average between a range of values in Microsoft Excel 2016 (or Office 365). I wish to find the average between the first non-zero and the last non-zero of each row. If I could break this up into 3 steps in the formula to calculate the...

Hey guys, I'm stuck on a part of the macros I'm creating. Im trying to create a table(table2), and the values in it are referenced from a table above(table1). however, table1 is dynamic, a new column is added every two weeks. in table2, the first set of values are the same as the last column...