1. J

    Referencing an "icon"

    On the INSERT menu of the Excel ribbon, right under "shapes" you can insert an "icon". Once you've done that, how can you reference the resulting picture via VBA? I tried searching but most of what comes up for "icons" is in relation to conditional formatting.... Thanks!
  2. Q

    Reference Multiple Sheet Names on one sheet

    Hi All, I have about 15 sheets in one workbook, which are named using numbers eg. 12345, 54321, 65432....etc. I'd like to reference/link the names of all these sheets on to one main summary sheet. This is different from referencing the sheet name within that same sheet. Is there some way to...
  3. N

    AutoFit Row height with cells that have a formula

    Hi all - whenever I used AutoFit Row Height on a row that is referencing data from another sheet(Lets say, Im on Sheet1 and Cell A1 is referencing Sheet2!A7), the row height does not expand to fit all of the text. Is there a simple way to get this to work? Obviously there is no problem when...
  4. J

    SUMPRODUCT question - referencing cell

    Hi all, The below code, I am trying to change the "<1" to reference a cell that contains the value 1. When I substitute the cell for the hard number, doesn't seem to work. Any ideas? Thanks! Range("E21").FormulaR1C1 = _...
  5. C

    Copy remote data into current file

    Hi i have tables with formulas referencing other tables, which are placed on the firm's remote server, where i login through VPN. Opening and saving of such files (referencing remote files) takes too much time and CPU power - until 95% of CPU power. And, i can't work with values instead...
  6. P

    Referencing Issue

    Hi I have two values in 2 different cells say <tbody> A B Forumla Used Result Excepted 1 10 20 =A1*B1 200 200 2 10 20 =ADDRESS(2,1,4)*ADDRESS(2,2,4) #VALUE! 200 3 </tbody> As u all can see that when using second formula there is some error which need to b rectified...
  7. J

    Referencing another workbook, COUNTIFS substitution

    Hello there, I'm wondering if there's an alternative to COUNTIFS when referencing cells in another workbook. The reason why I'm asking is because SUMIFS and COUNTIFS produces errors when this other workbook is not opened. Thank you in advance!
  8. J

    Insert New Worksheet

    Hi, I have worksheet 1 and worksheet 2. Worksheet 2 has formulas referencing to worksheet 1. When I make a copy of worksheet 2 and re-name to worksheet 3, in the same workbook, the formulas are still referencing to worksheet 1. Manually changing the formulas in worksheet 3 is tedious and I...
  9. M

    Multiple Worksheets Referencing One Worksheet

    I have a worksheet with about 60,000 rows and 20 columns. I need to make about 20 copies of the main worksheet and then filter slightly differently on each of the other worksheets. This is a daily process so I'd like to automate it more. I started off pretty basic with just a formula...
  10. D

    Cell referencing text shows zero

    Hi All, I'm referencing a cell on another tab by typing in the equal sign and then navigating to the referenced cell and clicking on it. The cell that I'm referencing has general number formatting but contains text. The cell that I have made equal to that text cell is showing a zero and not the...
  11. J

    Pasting and Referencing

    Hello, I am working with a multi column list of data that am pasting into one tab. This tab is going to be sorted into other tabs by referencing one cell e.g. a zip code. I have made a vlookup, referencing the one cell containing the zip code, however for my results, I get only the first...
  12. IluvPivots

    Sum previous columns

    In search of a formula that I can populate across columns. Right now it looks something like this: In cell J7: =($B7*J$3)-I7-H7-G7-F7-E7-D7-C7 In cell K7: =($B7*K$3)-J7-I7-H7-G7-F7-E7-D7-C7 Every new column subtracts the sum of the columns previous to it. The number of columns will continue to...
  13. M

    Complex Concatenation

    I am trying to concatenate a complex string of text and percentages and variances and struggling to get it to work. Can any geniuses out there assist me? A1 = "Revenue" A2 = % which could be +/- which is referencing Cell B2, ie -5.3%. Negative figure not required to be pulled through A3 =...
  14. R

    GetObject referencing worksheet question

    Hello forum guys. I want to know what is the way of referencing worksheet within the GetObject function. I know there are other ways of refering. On the MSDN documentation there is example of referencing the class and object with the syntax like this. Set LayerObject =...
  15. R

    3d referencing not working

    Hey There, I have a formula that works just fine when only using 1 sheet. I changed it to reference multiple sheets and it just gives an error? Any reason this could happen in google sheets? Original: =SUMPRODUCT(IF(MOD(ROW('Travis Jones'!C12:C)-ROW('Travis...
  16. D

    Help with referencing

    Hi, What I need help with is this - if A1 matches the data in D1 and B1 matches E1 then reference the data from from C1
  17. C

    Don't know what to do

    I have 5 documents with 52 tabs, one per week. I have another sheet where I want to consolidate the data. Because the sheets represent week numbers I want to throw in a criteria referencing the sheet name so that I can just copy and paste the formula into the weekly tabs of my master sheet...
  18. D

    Referencing a Cell for a formula

    Good morning. I am working on an Index/Match formula referencing sheets in a folder. Trying to figure out how to reference a cell rather than have to type or do a search replace every time. Here is the formula =INDEX('C:\Users\jdoe\Desktop\2019 Budgets\[Derr2019.xlsm]Area...
  19. C

    Finding first blank row number

    Help! This formula referencing text within the same page, works perfectly in returning the first blank row number: {=min(if(indirect(“A”&J17):A26=“”,row(indirect(“A”&J17):A26),””))} However, similar formula below referencing another page returns #VALUE...
  20. M

    Keep all references unchanged after sorting

    Take a look at the spreadsheet. The references will change after sorting and break the calculations. Absolute referencing is not an option. The table has to be copied periodically to another sheet and placed it at a different row (the columns are identical). Absolute referencing will break the...

Watch MrExcel Video

This Week's Hot Topics

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