+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 15 of 22

Updata data from sheets in master

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

    Updata data from sheets in master

    hi guys,

    i my file, in check x in column B, in column A is allocated a unique number. The rest of columns are copied in Master. i want if i modify something in a raw, updating in Master.
    Attached Files Attached Files

  2. #2
    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,995

    Re: Updata data from sheets in master

    Why not just something like...
    =Sheet1!A3

    Or, is your sample file too simplified?
    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. #3
    Forum Contributor
    Join Date
    08-21-2018
    Location
    Romania
    MS-Off Ver
    2010
    Posts
    161

    Re: Updata data from sheets in master

    my file is simplified, ii possible to have 1000 raws in every sheet

  4. #4
    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,995

    Re: Updata data from sheets in master

    OK, then maybe you need to show a more representative sample of what you are working with, along with what you expect?

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

    Re: Updata data from sheets in master

    i attached my file
    Attached Files Attached Files

  6. #6
    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,995

    Re: Updata data from sheets in master

    That helps a lot, thanks.

    Now, how do we know which data comes from which sheet?

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

    Re: Updata data from sheets in master

    i didn't think about that... maybe if in column B will be name of the sheet

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

    Re: Updata data from sheets in master

    in column D, sorry

  9. #9
    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,995

    Re: Updata data from sheets in master

    If thats the case, then we could probably use INDIRECT, instead of VBA?

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

    Re: Updata data from sheets in master

    if is working, is ok

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

    Re: Updata data from sheets in master

    can to give me an example, please?

  12. #12
    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,995

    Re: Updata data from sheets in master

    OK, can you update your file to show what it would look like with the sheet names?
    (It's late here, I need to go to sleep soon, but Im sure another member will pick up where I left off)

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

    Re: Updata data from sheets in master

    i attached the new file
    Attached Files Attached Files

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

    Re: Updata data from sheets in master

    some help, please?

  15. #15
    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,995

    Re: Updata data from sheets in master

    Apologies for the delay.

    Try this in A3, copied down and across as needed...
    =INDEX(INDIRECT($D3&"!A3:AG27"),COUNTIF($D$3:D3,D3),COLUMNS($A:A))

+ Reply to Thread
Page 1 of 2 1 2 LastLast

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