Challenge Copying and Pasting Formulas
I am looking for some help copying and pasting formulas across sheets.
We are working to implement an automated supplier management dashboard which requires that 13 data points are generated for every supplier across all of our project sheets. With all the suppliers, that means a lot of rows and formulas. We then need to compile across sheets and manipulate the data, so they cannot be in a sheet summary. Column titles and formulas are set up to be the exact same across all sheets in question. I have set up all of the formulas within the template that we use to generate the project and I can confirm that they are correct and functioning properly.
When I go to copy the formulas into the existing project sheets, only the value is applied, and the formula will not carry over across sheets.
There are ~550 rows that need to be applied to about 20 sheets, so doing these manually for every cell is really not an option.
Maybe I am missing something super basic, but how to I copy multiple formulas from one project sheet into another? (I know I will hit the 500 row limit, I can deal with that)
Help Article Resources
Check out the Formula Handbook template!