Is there an easy way to copy a section of rows and columns in a worksheet with formulas that relate to values within that same worksheet and paste it into a new worksheet without the formulas saying #REF!
Example i have =A1+B1 in C1 in worksheet 1. How can i copy C1's formula into Worksheet 2 and keep the formula intact? I know how to manually do this by inserting Sheet!1 into every formula, but I'm attempting to copy and paste hundreds of complex formulas into another worksheet and it would take an obscene amount of time to do it manually. Very grateful for any answers.