SJ McAbney
08-25-2004, 06:09 AM
I have the following formula:
=INDIRECT(CONCATENATE("'Business Won'!$Q7$",COUNTA('Business Won'!Q:Q)+5))
It doesn't work on a sheet with a space in its name.
When I was testing it on a sheet called Sheet1, it worked fine.
Any ideas how to get around this? There's going to be quite a few formulas like this.
=INDIRECT(CONCATENATE("'Business Won'!$Q7$",COUNTA('Business Won'!Q:Q)+5))
It doesn't work on a sheet with a space in its name.
When I was testing it on a sheet called Sheet1, it worked fine.
Any ideas how to get around this? There's going to be quite a few formulas like this.