Copy formula to multiple worksheets automatically?

So, I have 53 sheets in a workbook and in the first sheet I have this formula

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

in column P
to fill P2:P18 with the tab name in this case week 11. Is there a quick way to
fill all the other column P2:18s with the formula so as to give week 12, week 13 and so on?

Hi And180y,

If you want to enter the same value, or formula on multiple sheets, you need to select those sheets using their TABS. Control+Click on the tab until all you need are selected. Then add your formula to appropriate spot (P2?) on one tab and it will be on all selected tabs in/on P2.

I don't know if your formula will fill down correctly as I don't know what is in A1. Give it a try. Fill down while all those tabs are selected and see.

See a quick demo at: https://www.bing.com/videos/search?q...3B7D3791F86EF6
Hope this helps.