reference

I have a Public Sub that has Public declarations as Public sdProcess As New Scripting.Dictionary Public sdHeaders As New Scripting.Dictionary I would like to automate the activation of Microsoft Scripting Runtime using this code or something similar...

Good morning! I would like to modify this formula in a macro so that it always looks at a specific column reference (column K) ActiveCell = "=SUM('Review Tab'!K:K)" I've changed it to this: ActiveCell = "=SUM(INDIRECT(" 'Review Tab'!K:K"))" However, VBA now thinks that everything after...

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