+ Reply to Thread
Results 1 to 3 of 3

AutoFill Drag "copy" same cell with different worksheet names on a "Master" worksheet

  1. #1
    Registered User
    Join Date
    04-11-2020
    Location
    Philippines
    MS-Off Ver
    360
    Posts
    6

    AutoFill Drag "copy" same cell with different worksheet names on a "Master" worksheet

    Hello.. and thanks to all for reading this post.

    I have a "Master" worksheet that needs to copy the same cell from multiple different worksheets. The worksheet names are: Results (2), Results (3), Results (4).. and on and on.

    This is how I would like to AutoFill Drag to work:

    ='Results (2)'!$O$32
    ='Results (3)'!$O$32
    ='Results (4)'!$O$32
    ='Results (5)'!$O$32
    ='Results (6)'!$O$32
    ='Results (7)'!$O$32

    ....etc...

    I've not been able to get the name of the worksheet to actually change, it just copies Results (2) endlessly.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: AutoFill Drag "copy" same cell with different worksheet names on a "Master" worksheet

    Starting in row1 try =INDIRECT("'Results ("&(row()+1)&")'!$O$32") and pull down

  3. #3
    Registered User
    Join Date
    04-11-2020
    Location
    Philippines
    MS-Off Ver
    360
    Posts
    6

    Re: AutoFill Drag "copy" same cell with different worksheet names on a "Master" worksheet

    Quote Originally Posted by Pepe Le Mokko View Post
    Starting in row1 try =INDIRECT("'Results ("&(row()+1)&")'!$O$32") and pull down
    Not often I fall in love so quickly as I just did. I did try "INDIRECT" but could not get it to work, I think among other things I missed the +1.

    Thank you very much for this working solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] if in worksheet "test1" is in cell G2 to G1000 an entry"share sale" copy the row new sheet
    By torti111 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-22-2017, 12:28 PM
  2. Replies: 1
    Last Post: 01-22-2016, 09:21 AM
  3. "Worksheet change" not changing cell on other sheet to match target cell "fill".
    By Ochimus in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-02-2015, 12:02 PM
  4. Replies: 3
    Last Post: 06-05-2015, 01:55 PM
  5. If "value" then copy from "cellA" to "cellB" drag down issues
    By mrmeeks in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-18-2014, 12:34 PM
  6. [SOLVED] List names of other worksheets as data/text in a column of the "master worksheet"
    By ExcelHack3r in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 10-31-2013, 07:46 PM
  7. Copy rows between "STARTCOPY" & "ENDCOPY" and insert in another worksheet
    By mikeop99 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2013, 10:19 PM

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