I have the following formula in each sheet in a workbook:
=SUMBYCOLOR(A35,INDIRECT("o35:"&$B$6&"35"))
which works great (thanks to the help received on the forum yesterday )
The only problem is the project I am doing will involve me moving the sheets around (basically it is live document in the business so I can only amend the worksheets in small batches, and there are alot of changes needed to get them consistent.)
When I move the worksheets I had completed, the above formula returns the error NAME!. I did change the workbook name as I resaved it - would this be what is causing the error? IF so, can I fix/avoid it?
Many thanks again
Andrea
=SUMBYCOLOR(A35,INDIRECT("o35:"&$B$6&"35"))
which works great (thanks to the help received on the forum yesterday )
The only problem is the project I am doing will involve me moving the sheets around (basically it is live document in the business so I can only amend the worksheets in small batches, and there are alot of changes needed to get them consistent.)
When I move the worksheets I had completed, the above formula returns the error NAME!. I did change the workbook name as I resaved it - would this be what is causing the error? IF so, can I fix/avoid it?
Many thanks again
Andrea