Changing the worksheet name in multiple formulas (possibly using INDIRECT)

ToLoC999 · #5 11-24-2024, 06:14 AM

Hiya Pecoflyer,

Whatever I tried I could not get the syntax correct for a INDIRECT statement and therefore came up with a cunning workaround.

I created another formula in the worksheets (B13) that had the formula =IF(B3>0,1). Refer to the attached screenshot but this basically changed its value from FALSE to 1 as soon as the first score went in. From here I was able to write into the formulas to only include the worksheet if B13 = 1

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to run worksheet multiple times changing a single input?	jigadoo	Excel	4	06-08-2022 12:37 PM
Need a formula (possibly something like VLOOKUP) that will return multiple results.	SilverUnicorn79	Excel	8	08-16-2016 01:34 PM
Excel 2010 changing external link formulas automatically on Webdav mapped drive	dirkswart	Excel	2	10-07-2013 12:44 PM
Copy Worksheet and preserve formulas	silverspr	Excel	4	02-21-2013 07:51 AM
Protecting the formatting and formulas in a worksheet	furface00	Excel	5	02-27-2011 02:22 PM