Good morning,
Thanks for all the feedback you provide, this forum is very helpful. I have a table with multiple columns, each column is counting the yeses from another worksheet and there's one column for each sheet. I need to copy the formulas from one column to another column, the formula should be exactly the same with the exception of the name of the reference that is pulling the info from. Please see example below:
Copy this =COUNTIF(tree!C7:C22, "Yes")
And paste it as =COUNTIF(panda!C7:C22, "Yes")
I have Excel 365. Is there a way of doing that without actually going and manually replacing tree with panda? The column has about 200 rows so that would be a lot of work!
I'll really appreciate your assistance with this.
Thank you!
Andrea
Bookmarks