Not sure where to go with this one. I need to do subtotaling in a worksheet. I need to subtotal every time one column changes and then when another column changes. Is there a way to do it without the subtotal function?
A UDF would work but not the subtotal function because I need to export it to Access and I am not sure if the function would hang on to the parse or not.
Say I want to subtotal column A and column D how would you do that in a function? I want to export values only to Access. Thanks