formula as cell reference

I have 2000+ workbooks (A) in a folder (each having only one worksheet with data structured the same across all the workbooks). I also have another workbook (B) in a separate folder with: The first worksheet structured the same as the 2000+ single-worksheet workbooks and 4 additional...

I am trying to get a message box to fire automatically based on a cell value. Here is the setup: I have a "configurator" tab (Sheet 2) that has an ActiveX drop down box with a list of names that corresponds to a table of names/job titles on a logic tab (Sheet 3). When you select your name on...

Hi, So I am trying to create a Fantasy Football spread sheet. I want to create a formula that will read the team name in the cell next to it and then spit out the bye week that team has assigned. For example if E4="ARI" then I want F4=8 for their bye week being week 8. While it is easy to...

lastRow44 = Cells(Rows.Count, "A").End(xlUp).Row Range("A" & LastRow3).End(xlDown).Offset(0, 11).Formula = "=Sum(M50:M" & lastRow44 & ")" I have vba code like this, but I want to modify it to replace M50:M to ("A" & LastRow3) to make code dynamic. However If I replace it, it does not work. Is...

Hello all; new to the board. I'm really stuck on a problem. I'm trying to write a formula that will be used in conditional formatting. I have a calendar that uses macros and self populates the days when selecting a year using a spin button. I want to conditional format each day to change color...

Range("D2").Select Lastrow1 = Range("C" & Rows.Count).End(xlUp).Row Selection.End(xlDown).Offset(1, 0).Select Selection.Formula = "=0000" Hi guys, I am trying to putting value on below last row of D column and would like to extend value till last row of the column. Usually column C...

Hi All, I have an spreadsheet which consist of employee data and there revenue to generate an automate invoice. here is an image link https://1drv.ms/i/s!AnOR9mvtWzlzc6NUs4vHUtxOI5c M21 is the total cell which has name range as Total M22 is the StTax as name range. The grand total has...

I am trying to link two workbook by using formula in cell reference but it doesn't copy the changes in second workbook when I update the first one. Here is the Example: Workbook 1 A 1 10 2 20 3 20 4 50 Total Workbook 2 A 10 50 (=[Workbook 1.xlsx]Sheet1!$C16) formula to update cell A4 with...

Hello, I have taken over a form/ score-card on an Excel template. The previous owner has a formula/cell format I can't figure out. The cells can have a value entered of 1,2 or 3 and the cell will auto populate to a red, yellow or green circle. (traffic light) I tried clicking "Show formula"...

Not sure if this is possible but I'll give it a shot... The reports I run for payroll render an alphabetical sheet (with hundreds of employees) and their respective revenues earned in an adjacent cell. Our payroll spreadsheets are broken out by office location, so the destination formatting is...

I have a spreadsheet that displays results of a calculation worksheet, both in the same workbook. Status should only show when the "actual" cell is populated with a number/result from the calculation page. the status cell uses this formula "=IF(H16="","",IF(H16>=H15,1,0))" the Actual cell...

I have a workbook with three different columns and within each column are approx. 245 formulas. Each formula in a column references a workbook and each column has a different workbook that is referenced. The referenced workbook is labeled in row 3, such as A, AA, and AC all reference workbooks...

Hey Everyone. i definitely need some help. I am making an excel sheet and I have put in a formula =SUMIFS('23.03.15'!BH$4:BH$135,'23.03.15'!$C$4:$C$135,$C10,'23.03.15'!BG$4:BG$135,$D10).. Now the thing is When I drag it horizontally BH$4:BH$135 changes to BI$4:BI$135. What I want it is that I...

I'm halfway to solving this dilemma of mine. I have a table listing dozens of formulas some of which are custom built through a 3rd party API like Bloomberg financial(call that "FormulaTable") while others are more custom designed. A formula can be selected based on two criteria from a data...

Hi guys, So here is my problem. Im looking to make a summary sheet from my workbook highlighting key values from all the different sheets. What i want to do is use a formula to quickly get data from a different sheet that has the same name as the cell in my summary sheet. To explain properly...

i'm curious if this is possible: first, lets say at the bottom of my worksheet i have cells A100-A110 each containing the text of either "V1", "V2"....."V10", now say if i enter into a blank cell the text "V1", is there a way to create a formula where it turns that cell into a hyperlink to...

Dear Experts, I am facing problem to make summary sheet of top 3 value from large number of value of my excel sheet like- Sheet1 <tbody> Group Name Value 1 Nashid 200145 2 Kashem 188516 1 Jabed 184198 2 Rubel 172569 3 Romel 168251 1 Eman 156622 2 Hasin 152304 3 Nasim 136357...

I am trying piece together various code to create a macro. I am having a problem with one line of code. The error is that object does not support this property or method Where am I going wrong. Range(Cells(2, Found.Column + 1), Cells(LR, Found.Column + 1)).ActiveCell.FormulaR1C1 =...

I'd like excel to pull data from a sheet by recognizing the row label. I have a summary file every month I paste the detail file to another tab. The # of rows changes on the data sheet so my linked cell to the summary may pull incorrect data. Indeed excel to recognize the row that says Total...

Hi everyone, I'm trying to apply a formula to more than 20000 rows of excel on a mac. It takes too long to drag down the corner of the box so I was wondering if you know of any other ways. I know that you can double click on the corner of the first box but you can only do that for all the rows...