+ Reply to Thread
Results 1 to 22 of 22

Updata data from sheets in master

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

    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 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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
    178

    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 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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
    178

    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 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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
    178

    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
    178

    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 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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
    178

    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
    178

    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 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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
    178

    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
    178

    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 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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))

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

    Re: Updata data from sheets in master

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

  17. #17
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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))

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

    Re: Updata data from sheets in master

    another optio, pleasE?

  19. #19
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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

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

    Re: Updata data from sheets in master

    how can to do that with vba?

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

    Re: Updata data from sheets in master

    is possible to make this with vba?

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

    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

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Fix data in sheets from Master sheet
    By farrukh in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-02-2019, 04:29 PM
  2. Consolidate several sheets data in a master sheets
    By amy03 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-24-2016, 06:42 PM
  3. vba to updata data from one sheet to another
    By aaravgaba in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-28-2015, 06:24 AM
  4. Updata new data between sheets by VBA
    By dtaphuong in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-26-2015, 04:59 AM
  5. Populate data from sheets to master
    By Harlin67 in forum Excel General
    Replies: 2
    Last Post: 07-30-2015, 08:50 AM
  6. Find and updata data from one sheet to another
    By amarrforever in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-26-2009, 06:19 PM
  7. Referencing and updata master sheet at set intervals
    By freud1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2009, 12:21 AM

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