recon

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

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

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

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