Forum Discussion
Can formulas be made to change dynamically when copying sheets?
Hi! I have a workbook with two worksheets, Sheet1 and Sheet2. Sheet2 has 7 columns and 15 rows with a number in each cell. Sheet1 A1 references A1 on Sheet2 with the following: =SUM(...
This is kind of fun. I need to warn you that INDIRECT is what's called a volatile function. But this does look like it works with multiple columns and added sheets.
Hi! I'm glad you're enjoying this! I am too! 🙂
I opened what you posted and I'm having a hard time making heads or tails of it. I've been up since about 12:30 am and I think my brain space is gone for the day, lol.
I'm going to check it out tomorrow and get back to you. Thank you SO MUCH for this, Mathetes!!
Have a great night! 🙂
I opened what you posted and I'm having a hard time making heads or tails of it. I've been up since about 12:30 am and I think my brain space is gone for the day, lol.
I'm going to check it out tomorrow and get back to you. Thank you SO MUCH for this, Mathetes!!
Have a great night! 🙂