Skip to Content
Former Member
Dec 20, 2010 at 11:28 AM

XL reporter: How to return values only to worksheet?



In the intrest of distributing report results to computers where macros are not allowed, is there any way to return actual cell values to reports instead of the ixGet("xyz") or SUM(ixRange1)? You can create a macro to copy and paste values, but I could not get it automatically run when opening the workbook. Any hints or more clever solutions for the problem?