reference

Hi! Wondering what the best way to sum a number of columns based on a particular cell which is dynamic. <tbody> I can use this formula when E3 is static, but wondering how to get E3 to be dynamic based off a cell value <tbody> =SUM(OFFSET(E3,0,-3,1,3)) </tbody> </tbody> Example below...

The goal here it to create a summary sheet. In that summary sheet I need to reference sheet 1 that holds all the products. Sheet 1 has all the products in one column, but some of them do repeat. My thought is to create IF statement that could call out one product in sheet 1 for the entire...

I want a drop down list in one workbook that references a dynamic list in another workbook ie it may have entries added to it so I can't hard code the reference? If I select data validation for a cell, I set it to allow a list but what do I put in the source for the list to be from another...

I need to include a Comma plus 1 blank space to come before a wildcard reference to a cell content with countif/countifs Here is how the formal looks without the comma and blank ", " added =COUNTIF(ref_name,"*"&$A1&"*") Is this possible?

I am trying to copy the following formula that has multiple If Statements referencing multiple other cells for the desired results and only the first cell referenced but not the follow 3 cells referenced in the desired results. =IF(A2=1,'Team 1'!B13,IF(A2=2,'Team 2'!B13,IF(A2=3,'Team 3'!B13...

Hello all, I have a code that creates an array SUMPRODUCT formula and for whatever reason the R1C1 part of the formula is the only thing not working. I am sure I am doing something weird but hopefully someone can spot the mistake and provide a revision. Here is the line of code: sF1 =...

I've been doing some work to identify some issues with the data in a couple of my database tables. I've got one table [tbl_customer] with a reference number (unique) and details of customers, and another [tbl_sales] with details of the products that they've purchased (many products and many...

hi guys, i would like to ask how can i resolve this..... Below is my actual data. date time temp 1 10/7/2019 0:12 120.3 2 10/7/2019 0:13 119.5 3 10/7/2019 0:13 121.3 4 10/7/2019 0:13 120 5 10/7/2019 0:13 121.2 6...

I'm using the below code to check for existing records (in case the user of my UserForm clicks "add record" instead of "Update" 'Checks for existing record in case user clicks Add record instead of update. Dim reference As String reference = UserForm1.Ref_Num.Value Dim aCell As Range 'Set...

Hi, I have an Access Macro. In this macro, Microsoft Access 14.0 Object Library is ticked in Reference. I want to un-tick this reference. However while doing so I get pop-up as ‘Can’t remove control or reference; in use’. How do I find out what objects in my macro are related to this reference...

Hello All, I have a requirement, where in i have a master sheet, with Sheet Name reference, column Name, what i have to do is =Sum(sheetname reference with indirect formula),column Name reference in master sheet, where the columns in data sheet is in A5:D5).

Have a question if I may, I want to use two adjoining cell;let say C3 & D3 and I would like to be able to put a figure in either ofthese and have the empty cell calculate either way. How can this be achievedwithout causing a circular reference? Steve

Hello, I've workbook with some 100 sheets. This number increases each week. In each sheet there is a table with different dates and values assigned to these dates. Each sheet has a same structure. The difference is only in the entered dates. I have to consolidate by dates to get sum of...

I want to make a dynamic Indirect formula. My goal is to take a cell reference for a sheet, and also a reference of a cell on that sheet. So far I have this in cell B2: =INDIRECT(B$1&"!O2") Cell B1 is January. I want to reference the cell O2 in the January Sheet. This works, however, I want...

I want to make a dynamic Indirect formula. My goal is to take a cell reference for a sheet, and also a reference of a cell on that sheet. So far I have this in cell B2: =INDIRECT(B$1&"!O2") Cell B1 is January. I want to reference the cell O2 in the January Sheet. This works, however, I want...

Hi! Im working on a worksheet where i plan on making a lot of userforms that reference into a table. I want to make this more "dynamic" so that my code goes by the column name instead of a hard column number incase i need to add more columns in the future. This is the code i have so far, it...

Hello All, I have a large accounting file with parallel construction which I need to pull into each of my assets Profit and Loss Statments. Each asset has a separate PnL page, and in my accounting worksheet, I have each asset named seperately. I'd like to create a formula where I type in the...

Hi, I'm new to VBA, I'm recording a macro to format a specific file that a team uses to work through a que, I'm trying to get my macro to reference the workbook regardless of the changing number in the file. This name change is caused by the way the file downloads in certain browsers i.e chrome...

Is it possible to reference a cell for it's text? The problem I am trying to fix is the following: =SUMPRODUCT(COUNTIF(January!E36:E36,{"Completely Satisfied","Very Satisfied"})) I am not in the January sheet. However, the cell E36 in the sheet I am in contains "AI", which is actually the cell...

Hello, The formula in my calculator answer cell is =F10/LOOKUP(F10,Sheet1!$B$3:Sheet1!$B$1000,Sheet1!$C$3:Sheet1!$C$1000)+F5 But I would like to reference a different "Lookup" depending on the value in F4 If F4 is below 15 I would like to reference columns B & C (as in the current formula...