#vbacodes

  1. Jyggalag

    Help with possible IFERROR(INDEX(MATCH))) formula

    Hello everybody, I currently have an excel sheet that looks similar to this (but much larger): And then a master data sheet next to it that looks like this: Please note that some of the titles are not in the master data set (in reality however, they all are, i just created this example...
    • Jyggalag
    • Thread
    • #vbacodes code 128 easy excel fast formula formulas count help - names iferror index index & match match
    • Replies: 2
    • Forum: Excel Questions
  2. A

    MACRO Reference multiple cells that have values that differ from each sheet

    At work I have a URL that has multiple parts, and I am able to reference specific cells in each sheet in my excel workbook. Some parts of the URL are the month, year, account, and the specific report type I would like to access. I have created a hyperlink that takes me to our company website...
  3. P

    What "IF" formula/Macro should I use to automatically choose which among the sources releases most recent data

    In a worksheet, I have three rows of data from three different sources. I need to get the data from whichever of three sources releases the most recent data.Example: Let's name the sources, Source 1, Source 2, and Source 3 in one column. In another column is "Last Update" which refers to the...
  4. P

    Macro to Copy value from last cell in column and paste to other cell in another sheet

    The worksheet where my data are coming from is named "Currency" sheet. This sheet automatically generates historical data/prices of currency rates (also equities) from Bloomberg daily upon entering the date range. Upon entering the date range, the most recent data/yesterday's closing price are...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top