refer

Hello, I'm trying to make a formula like this in order to refer to scores in my "Scores" sheet form a different sheet: =INDEX(Scores!$A$1:$AP$55,MATCH($A5,Scores!$A$2:$A$55,0),INDIRECT("Scores!"&"COLUMN((TODAY()-WEEKDAY(TODAY(),2)+5))")) But I can't get the bold part to work correctly in...

I'm sorry in advanced if my explanation isn't very clear, but here goes! I've got a grid of results from four teams who are scored on a weekly basis. So far, my calculation has the following which highlights how many times each team has won (listed at the top of each team)...

Hallo, The workbook contains sheets with name containing parenthesis. Ex. (1), (2),...I want to refer to them using the next function but it doesn't work. It works when the parenthesis are removed. The function is: =INDIRECT(CONCATENATE(B2;"!F";B1)). Cell B2 conains sheet names Cell B1...

I have a formula: =SUMIF(DINOSAUR!$C$12:$C$37,K$3,DINOSAUR!$A$12:$A$37) where DINOSAUR is the name of another sheet in my workbook (it's also the name of a clinical trial) But the name also appears in cell F4 as shown here. Now I need to replicate this formula down the sheet for many other...

Hi, Not sure if it is possible, but I am looking for a way to move contents of a dropdown into individual adjacent cells. Please refer to link below that contains small test file. https://ufile.io/itmb6 Thks.

I am trying to write a Macro that would select the Active Table in the Active Sheet in the Active Workbook for data stored in "C3:H9". I know the following VBA references can be used: "Application.ActiveWorkbook.ActiveSheet.ActiveCell" can be used to refer to the ActiveCell as mentioned in Link...

I have a workbook where I create a new sheet daily, Monday through Friday and it is named for the current date in ddmmm format. I run a macro to format the sheet like I want it. I also need to pull some data from the prior day's worksheet. Can anyone tell me how to refer to the sheet name for...

Hey guys, new here so appreciate any help. I have worksheet A with 72 formulas that all reference the same column (but several different rows) in a different worksheet B. Is there a way to copy worksheet A and then quickly change all the formulas so they refer to a different column in...

The title doesn't say much so let me explain further. The value in A2 is manual input and it could be any date in the calendar, from 1999 to 2017. In column B, I need to enter a formula that returns which ever comes first, November 6th or the day and month of A2 + 1 year. Refer to table for an...

Hey, So I've started to pick up on using codenames when writing scripts, majority of them I can pull them off or learn the workaround but in my example.. say I have 10 sheets, all codenames are sheet1, sheet2, sheet3 etc.. why does this code not work when referring? Why does it not pick up as...

Friends, I have a conceptual question regarding VLOOKUPs. I already know it is poor practice to associate a larger table_array with a VLOOKUP than is necessary (i.e. don't refer to A:ZZ if you are returning column D, just refer to A:D), but I'm wondering how much does this affect overall...

Hello Friends, I would like to reference the name I give worksheet in a formula. The Situation: I am creating a weekly review chart for a dynamic sales availability: how much of each product we are projecting available for sale in the next 18 months. The Availability is generated in a...

I'm doing some things with arrays but stuck on the syntax using the format array(i, 4) can anyone tell me how I would refer to the range array(i,1) to array(i,5) , I'm just trying to set the values to nothing within that range but unsure of the syntax and don't want to set each one separately if...

I would like to refer to a value in column A for each row. For example, when the value in A2 = the value in column J and the values are greater than V2 (8/29/17) and less than X2 (9/13/17), then sum column P. The formula works, but it's a lot of copying and updating formulas as I need to...

Not sure if this is possible, but at the moment I am referring to Tables in a Word document from Excel as follows; WordDoc.tables(1) Is it possible that I can name a Table in the Word document, (which is a template), and then refer to it by name in my code within Excel?

hi I want to copy the cells by random range and paste it in the same random range for example refer the insert image Thank you

Hi, I am trying to link /reference the main data which contains monthly data but has fixed blank columns to another work sheet. I tried offset however the formula doesn't move skip the cells i want to refer to in order. See attachment as reference. Would appreciate any help/suggestions...

Hi, I use this formula to create a hyperlink to a file stored in the location stated within the formula. ='\\file\projects\BUSINESS IMPROVEMENT\BUSINESS IMPROVEMENT STORAGE\32\PROJECT CONTROL\[32.xlsm]CONTROL REGISTER'!$B$13 The number 32 in this case (in red) has to be added manually...

Hi, I am solving a problem. I need a macro, that does certain operations on several sheets in workbook, but due to the actual sheet names changing based on specific projects and people adding new sheets, the only viable option is refering the the sheets by their codenames. Can you loop through...

Hi all, I would like to ask how to refer a cell an read a value from there. Selection.Resize(4).Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove I want that resize number refer to a cell and read that. For example in "BW5" cell there is a number (let's says 5) How should i refer...