1. Chris_010101

    Sum columns on multiple sheets

    Hello Using the basic salary column on FY 22-23 as an example, I need a formula to sum this column into basic salary on the stats sheet, if possible using the sheet name in column A as a reference to the sheet to sum from. All columns across all FY sheets are set out the same. Stats sheet...
  2. M

    Stepping outside the range of a cell

    Suppose you have have a cell: Set FirstCell = Range("B4") and this reference: FirstCell (4, 6) What does the reference reference?
  3. brendalpzm

    Copy and paste formulas from a workbook to another without reference with VBA

    I have 3 workbooks, one of them (wb1) has a vba code that copies some formuled cells (a1:c23) in a worksheet from wb2 and copies them in a worksheet in wb3. The thing is that the formulas copied in wb3 are referencing the wb2 instead of wb3, how to copy without this reference?
  4. Rainbow_P

    Please help: Reference error in GETPIVOTDATA (pivot table in another sheet)

    Good day! Can you please help me with a reference question? A workbook has 2 sheets. Sheet1 is a pivot table. In sheet2, I use GETPIVOTDATA to return some values from the pivot table in Sheet1. In sheet2, cells C2 and D2, there are direct formulas when I just clicked the cells (I want to...
  5. E

    Change Pivot Data Source Based on Cell Selection

    Hello, Workbook name: Report Sheet with pivot: Summary Sheets with data source: Source1 , Source2 (data in range A1:C14) In the above workbook, I defined the name PivotChange_Source with formula =INDIRECT(Summary!$A$1&"!A1:C14") to change the Pivot source within the Workbook based on A1 input...
  6. F

    Tab Reference in Formula

    Hello Excel Experts, I need some help (if possible) regarding formulas that contain a tab reference. Specifically, I am trying to find out if I can incorporate a formula that based off of a text contained in the same cell on every sheet, that it would change which tab will be referenced. In the...
  7. D

    Referencing Cells from a Separate Work Book, but NOT Cell Position

    Hi Everyone! What I am trying to do is link start and end dates from one work book into another, but not the exact cell position where the date currently is. I can do the first part easily enough by putting "=" in the cell of my current work book, and then selecting the date cell from my...
  8. R

    Referencing multiple cells in different rows to give an output

    Hi! I am trying to link multiple calls in different rows with a formula I am using. The formula I am using is: =IF(ISNUMBER(MATCH(DAY(F2),J28:M28,0)),"Holiday","") Basically what this is doing is, that if cells J28 to M28 contain a value, it matches it to the date in cell F2, and if it is a...
  9. V

    Loop Through Sequential Variables for UDF

    Hi all. I am trying to see if it is possible to loop through a series of variables with a standard naming convention. I am using this to create a UDF for me to use. What I am hoping to achieve is something like this where I can choose to enter up to a certain number of ranges as arguments for...
  10. E

    Sum function returning 0

    I have a spread sheet where I'm trying to get a calculation of a sum of two cells where their data is referenced from two other sheets. And I'm getting 0 as a result. What I'm trying to do is: in cell R10, I want R10 to =SUM(O10:O11). It should =80 but it's not. Formatting is the same on all...
  11. R

    [VBA] Trying to use sheet names in listbox as source to run code - can't figure out reference

    Trying to keep this as simple and clear as possible as it is pretty involved but happy to post more to get to a solution if necessary. I've got a command that works. I'm trying to shift from using a cell (cell is a named range) where you input a sheet name and it does the action on that sheet...
  12. H

    Create tab with dynamic summary info pulled from multiple other tabs

    Hi, To give you a bit of background I work for a property company and we currently keep our database of properties on Excel. There are multiple entities and each entity has a tab on a workbook, each entity tab contains the same column headers across the top and down the side are the list of...
  13. MDHolmes

    Populating a wage based on a drop-down list

    I'm pretty much self-taught on Excel, and I'm really having trouble with this... I have two worksheets in my spreadsheet, the first is Labour Tracking, the second Data. My Data worksheet has a list of seven employees in Column A and their corresponding wage in Column B. The number of...
  14. G

    Conditional variable type declaration

    I have an API module that suppose to work for multiple programs. The object type refer to different reference for each program, but they are actually same functions inside the library so VBA code would be same for each program. I want to make my code short (implement DRY). Ideally, I would...
  15. G

    reference cell even the row is deleted

    i have no clue to doing this man, i expect the output is to be the right chart, but on the left chart is what i’ve done i want the cell to still remain the same number even the row is deleted and if i add new no. it still going +1 i need your help guys
  16. A

    Sumproduct in VBA linking to external (opened) workbooks

    Hi, I have this piece of code: With Workbooks("MyWorkbook.xlsx").Worksheets("MyWorksheet") Workbooks("OtherWorkbook.xlsb").Worksheets("OtherWorksheet").Cells(i, "MR").Value2 = _ .Evaluate("SUMPRODUCT((W2:W150000=MYRANGE)*Z2:Z150000,AA2:AA150000)") End With The code seems to work if I...
  17. S

    Drop down list selection to fill down results on multiple rows

    Hi! I've been breaking my head trying to figure out and or find an answer on how to use a drop down list (of names) to fill down a column with the results. More detail. Lets say I have multiple sheets, each with a name, an a list of objects they own like this: And on another sheet, I have a...
  18. E

    Copy formula and paste into next cell down - updates references of formula

    Hello, Please could someone help. I have no idea how to edit it to get it to do what I want. If I fill down the formulas, the offset won't work because there is already numbers in the V column Here is my(someone wrote this for me originally) code: Sub RectangleRoundedCorners2_Click() Dim...
  19. A

    Creating a dynamic file 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...
  20. 3

    If you insert an object (pdf) to a cell (linked or not), can you reference it from another sheet?

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back