formula as cell reference

  1. D

    Copy data from multiple single-worksheet workbooks into another workbook that contains formulas

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

    Message Box VBA

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

    Read text in one cell and fill another

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

    vba setting up starting cell to fill down formula

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

    Search an array located by referencing a date match

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

    selection cell phaste formula till last row

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

    Excel VBA error with sum formula

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

    How To Make Formula Work In Two Different Workbook

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

    I need a Value to Populate to an Object or Icon in the cell.

    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"...
  10. S

    Copy/Pasting from sheets with different formatting

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

    Need help with formula that references cell that has reference to another worksheet. not showing as blank

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

    Formula to reference external workbooks

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

    Help Needed: Pattern Formula.

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

    Apply a string value to the active cell as a real formula with cell reference

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

    How to make a cell reference in a formula equal a cell with the same name as a different sheet in the same wokrbook

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

    creating a hyperlink in a cell after a different input is added in that cell

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

    Help for formula to find Top 3 value in excel

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

    problem using formula in VBA macro Excel 2010

    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 =...
  19. X

    Formula data from 1 sheet pulled to another

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

    How to copy formulas in 20000 rows in excel without having to drag down the corner of the box?

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

Some videos you may like

This Week's Hot Topics

Top