reference

I need help creating a dynamic file reference in Excel (Please let me know the correct terminology as well). Currently, it is "='[SDR2021_AFG_NN.xls]Forecast NN 29 -- T5B5 -- AFG'!C2" I want to do something like this: "='[SDR2021_$P$94_NN.xls]Forecast NN 29 -- T5B5 -- $P$94'!C2" In cell...

Good morning, I have a list of about 10 people. These folks have added files to a folder (same folder where the excel file is located for ease). I'd like to run a list where names are in ColA and next to them in ColB I would attach the files (in whatever way makes this work). I'd like to...

Hi, I am hoping someone could assist me please. I am helping someone with a spreadsheet and they are wanting to flag dates at various stages. Essentially they are looking for two queries; - When 10 business days have passed column P (Closing date), column W (Selection Report finalised) will...

Good Evening, I am trying to find a code that allows the filtering of various Pivot Tables located on different sheets within the same active Workbook. For example, one of the active Workbook have the following pivot filtering conditions: Sheet Name "Group" Sheet Name "Purpose" Sheet...

Hello I have a workbook that recives data from an external source (WB01). I am trying to create another workbook (WB02) that looks at certain cells in WB01, as the data in WB01 changes then the this is reflected in WB02. I have both workbooks open and they are in the same folder (I have no...

So... basicly what the title says. I have a formula which lets me filter values from a huge table as a database. the formula is as follows: =LET(Advanced, IFS(F2<>"",SEARCH(F2,'Verbrauchsmaterialien Datenbank (work in...

Hi, I wrote the following formulas in Cell B2, C2 and D2 of Sheet 2: B2: =IF(AND(Sheet1!T2<20160000;Sheet1!U2>20150000);Sheet1!V2;"No") C2: =IF(AND(Sheet1!X2<20160000;Sheet1!Y2>20150000);Sheet1!Z2;"No") D2: =IF(AND(Sheet1!AB2<20160000;Sheet1!AC2>20150000);Sheet1!AD2;"No") I want to drag this...

Hi, I have a list of names and range references to load into name manager. Do you know if there is a way to import them in bulk. For reference I've tried create from selection but it can only store values not the range reference. Example of name to import Name_1...

Hi everyone, I trying to find the end date of production for a given production order. As in the table, I have the start date, of the production, however, the production may take up to 3 days (from 15/01 - 17/01) and officially ends in 18/01. But I cannot find an appropriate formula to find the...

Hi, I have a very long formula using nested IF formulas. It is basically checking different columns showing management chain levels and returning a value if a certain manager is in it, and if not, continuing down the IF chain. There are a few pieces that are repeated many times that I would like...

Hi everyone, I have a worksheet called DATA TABLE which has some 30+ columns. Located in column A is the specific site name. I have another worksheet called DATA AMEND which I am able to populate specific cells with information from DATA TABLE. I wish to then alter any of the cells in DATA...

Let's say Cell A1 in "WorksheetA" references Cell A5 in "WorksheetB". When you copy Cell A1 to Cell B1, its formula would of course typically adjust to reference Cell B5. However, let's say I'd instead like its reference to adjust by five columns, not one column. (That is, without changing...

Hello, I have created an ActiveX server control that I'm using from within VBA. But when I create a new version of this control on the user machine I need to go to References uncheck the reference click on OK and then again I need to go to the references and add it to get the fresh version. The...

I have a table which has a ToggleButton next to each line. I would like to write a script that does something for each line of the table, but only if the ToggleButton on that line is pressed. Is there a way to define the if condition in an elegant way? I would imagine something like: For i =...

In one workbook, I have a column A which A1 contains "Cities". In another workbook there is a "Cities" column, however, it's not in a static position. Is there a formula that I can use to look across Row 1, find "Cities", and list all the not empty cells in that column on my local workbook...

I am trying to use CountIfs and every thread I come across all reference when someone is trying to reference the same cells for different criteria, which I understand why that does not work. What I am trying to do is reference three columns all for different data, but I am getting zeros...

I have two excel files, one is file named data and other one is flile named format. The data file has multiple sheet named as "north" ,"south" and "west", each of these sheets have a reference column containing values a, b,c,d,e as values of first column and dates from Nov 4 to Nov 10 as values...

I'm trying to write the following formula: =MAX('02'!C5:C18) But instead of referencing the sheet named "02" I either want to reference a cell that outputs the name or number of the sheet, or have it reference the current sheet (because there are 200 sheets just like this one and they are all...

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