+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 22 of 22

Updata data from sheets in master

  1. #16
    Forum Contributor
    Join Date
    08-21-2018
    Location
    Romania
    MS-Off Ver
    2010
    Posts
    161

    Re: Updata data from sheets in master

    sorry, but doesn't working, can to put in my file?

  2. #17
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    47,059

    Re: Updata data from sheets in master

    My formula was a bit off....
    =INDEX(INDIRECT($D3&"!A3:AG27"),COUNTIF($D$3:$D3,$D3),COLUMNS($A:A))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #18
    Forum Contributor
    Join Date
    08-21-2018
    Location
    Romania
    MS-Off Ver
    2010
    Posts
    161

    Re: Updata data from sheets in master

    another optio, pleasE?

  4. #19
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    47,059

    Re: Updata data from sheets in master

    Why? What was wrong with the updated formula I gave you?

    It work just fine in your sample WB
    Attached Files Attached Files

  5. #20
    Forum Contributor
    Join Date
    08-21-2018
    Location
    Romania
    MS-Off Ver
    2010
    Posts
    161

    Re: Updata data from sheets in master

    how can to do that with vba?

  6. #21
    Forum Contributor
    Join Date
    08-21-2018
    Location
    Romania
    MS-Off Ver
    2010
    Posts
    161

    Re: Updata data from sheets in master

    is possible to make this with vba?

  7. #22
    Forum Contributor
    Join Date
    08-21-2018
    Location
    Romania
    MS-Off Ver
    2010
    Posts
    161

    Re: Updata data from sheets in master

    how can to update all data in master if in another sheet something is changed?

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

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