Copy and Paste formulas for multiple tabs

[cuslyguy]

Good morning,

I have built a few formulas that are designed to tell me the most recent version for a piece of software in a list of versions, a formula to tell me the most common occurrence of version from the same list as well as some other v-lookups. the formulas all work swimmingly. All of these are in a single row on a summary tab. The summary tab is designed to provide a single view summary on 1 tab for 80ish other tabs in the same workbook.

I want to be able to copy and paste my formulas down, but I don't know how with the 79 other tabs all be separate and having unique names. Any ideas how to help me?

 

[mehidy1437]

Just a simple trick, Ignore if you know already.
If you want to put the formula in the same cell in all sheets, just copy the formula in one sheet & then select all sheet & press f2 on the formula cell, then it will add the formula in all the selected sheets.

 

[cuslyguy]

thank you for the tip mehidy1437 - was that answer designed to answer my question or just to provide a useful tip on the subject?

 

[mehidy1437]

consider it's a useful tip on the subject