Hello Experts,
What's the workaround so that the sheet names listed within column A could have spaces? This formula only works without any spaces in the name
=INDIRECT(A1&"!e30")
where A1 is Sheet1. but if change A1 to Sheet 1 and rename the sheet also, then it's a #REF! error.
Thanks in advance,
Ricky
Bookmarks