+ Reply to Thread
Results 1 to 3 of 3

Copy formula to multiple worksheets automatically?

  1. #1
    Registered User
    Join Date
    02-28-2020
    Location
    Midlothian, Scotland
    MS-Off Ver
    365
    Posts
    54

    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?
    Last edited by And180y; 03-26-2020 at 07:47 PM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Seattle, WA, USA
    MS-Off Ver
    MS Office 365 Excel 2016
    Posts
    14,825

    Re: Copy formula to multiple worksheets automatically?

    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.
    Last edited by MarvinP; 03-26-2020 at 07:07 PM.
    One test is worth a thousand opinions.
    Click the * below to say thanks.

  3. #3
    Registered User
    Join Date
    02-28-2020
    Location
    Midlothian, Scotland
    MS-Off Ver
    365
    Posts
    54

    Re: Copy formula to multiple worksheets automatically?

    Thanks Marvin, copied to the columns and filled down perfectly. Thanks so much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1