recon

  1. B

    Using Personal.xlsb - referencing active workbook in VBA

    Hello, I have a macro which I saved it under a personal macro workbook as a few of our users would need to run it on a different workbook everyday using a shortcut command. But when I do that, it keeps referenncing to the personal workbook and not the workbook that is being run from. Can you...
  2. C

    Sum horizontal and vertical based on criteria

    I am trying to get the sum of a product in column A:A with the amounts in columns AD:JN. I tried this sumif formula =SUM(IF('Apr 8-CM GL v ACS Recon Detail'!A:A=$A13,$AD:$JN)) and it returns zero. I tried sumproduct =SUMPRODUCT('Apr 8-CM GL v ACS Recon Detail'!AD:JN,'Apr 8-CM GL v ACS...
  3. S

    Nested Sumifs, to calc first instance only

    I'm struggling with the below formula in Column C. I'm trying to return only the first instance of the data in Column A while maintaining the if statement to column D. <tbody> A B C D 1 GL Recon '=ROUND(IF(D4="Y",SUMIFS($B$13:$B$17,$A$13:$A$17,$A4),IF(D4="N",0)),2) 2 Invoice# Amount...
  4. M

    Save Single Worksheet as own file

    Hi All, I have a workbook with multiple sheets in it. I am attempting to save a single worksheet from that workbook as it's own excel file. I am having issues with getting it to work, and now seem to be getting further from where I need to be. Can anyone help out. Here is what I have so...

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