Shazam
08-26-2015, 01:06 PM
Hi,
A couple of users here are using Biznet. It's a reporting & analysis software. It's basically an add-in to your Excel workbook.
http://www.swktech.com/uploads/2014/01/bizinsight_product_brochure_web.pdf
(http://www.swktech.com/uploads/2014/01/bizinsight_product_brochure_web.pdf)Biznet have updated their software and now requires to to use additional argument in their functions.
My problem is that the users has allot of workbooks that also contains allot of worksheet tabs using the Biznet formulas.
Is their a VBA code I can run that can sip through all Biznet formulas on that particular worksheets and add the additional argument (Consolidated) to the Biznet formulas?
Look at the attachment below.
All I needed is the "Consolidated" to be used in all BizNet formula Functions. If you look at attachment Capture2.PNG, the Consolidated argument always has to be reference.
A couple of users here are using Biznet. It's a reporting & analysis software. It's basically an add-in to your Excel workbook.
http://www.swktech.com/uploads/2014/01/bizinsight_product_brochure_web.pdf
(http://www.swktech.com/uploads/2014/01/bizinsight_product_brochure_web.pdf)Biznet have updated their software and now requires to to use additional argument in their functions.
My problem is that the users has allot of workbooks that also contains allot of worksheet tabs using the Biznet formulas.
Is their a VBA code I can run that can sip through all Biznet formulas on that particular worksheets and add the additional argument (Consolidated) to the Biznet formulas?
Look at the attachment below.
All I needed is the "Consolidated" to be used in all BizNet formula Functions. If you look at attachment Capture2.PNG, the Consolidated argument always has to be reference.