+ Reply to Thread
Results 1 to 13 of 13

how to automatically update data in multiple sheets

  1. #1
    Registered User
    Join Date
    03-13-2014
    Location
    Athens, Greece
    MS-Off Ver
    Excel 2007
    Posts
    59

    how to automatically update data in multiple sheets

    Hi all,

    If you see the attached file, you will see a workbook with 46 sheets. The first one the "master file" is the one to add data and those data I want to be distributed in the other 45 sheets based on the agent name I have in the column A (the 45 sheets are named by the agent name). All sheets are similar.
    Every day I will add more data in master file and all the sheets should be automatically updated...

    I cannot use vlookup since the common column is the agent name and I have many rows by the same name.
    Is it possible?

    I saved the attachment as xlsx because it was too big..

    If anyone can help me I will be grateful...
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-19-2014
    Location
    India
    MS-Off Ver
    Excel & VBA - 2007 & 2010
    Posts
    60

    Re: how to automatically update data in multiple sheets

    Hi,

    Please have a look to attached link it will be more helpful, as i question is similar.


    Please Login or Register  to view this content.
    Thanks!
    Moinuddin Shaikh

    If you like my Response:
    1. Show appreciation to those who have helped you by clicking "* Add Reputation" below their posts.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    Appreciate someone towards their career path is better than saying Thanks!
    -Moin

  3. #3
    Registered User
    Join Date
    03-13-2014
    Location
    Athens, Greece
    MS-Off Ver
    Excel 2007
    Posts
    59

    Re: how to automatically update data in multiple sheets

    Hi moinsk21,

    Thanks for helping me.

    The solution you provided in the link is "Select All Sheets and input the detail in one sheet, so it will update to all sheets". I think this doesn t work for me.

    I need whenever I paste some raw data in "master file" sheet the rows where in column A is the "agent 1" to go to the sheet "agent1", the rows about agent2 to go to the sheet "agent2" etc.

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: how to automatically update data in multiple sheets

    The following code will copy the data from the Master file to the corresponding sheet as soon as you start filling data in the Master file.
    Please Login or Register  to view this content.
    For detail, see the attached sheet. The sheet Master file is blank sheet. Just fill the data in it and see if the filled data is populated in the correct agent sheet.
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  5. #5
    Registered User
    Join Date
    03-13-2014
    Location
    Athens, Greece
    MS-Off Ver
    Excel 2007
    Posts
    59

    Re: how to automatically update data in multiple sheets

    hi sktneer,

    Thank you for helping me!

    I paste some rows with name agent1 & agent2 in the file you attached but nothing happened...(the rows didn t go to the agent1 & agent2 sheets)
    I am not familiar with codes..Did I something wrong?

  6. #6
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: how to automatically update data in multiple sheets

    The above code (Post#4) is helpful when you add a single row at a time in the master file. But if you are pasting multiple rows at once in the master file, try the code given below......

    Please Login or Register  to view this content.

  7. #7
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: how to automatically update data in multiple sheets

    Remember this code is for worksheet change event. So right click on the sheet Master file and select View Code and paste the code in the opened code window.

  8. #8
    Registered User
    Join Date
    03-13-2014
    Location
    Athens, Greece
    MS-Off Ver
    Excel 2007
    Posts
    59

    Re: how to automatically update data in multiple sheets

    still it doesnt work... Did it work in your workbook?

  9. #9
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: how to automatically update data in multiple sheets

    Modified the code. Please find the attached sheet to see if this works as per your requirement. To view the code on the sheet, right lick on the sheet "Master file" and select View Code.
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    02-10-2014
    Location
    Liverpool, England
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: how to automatically update data in multiple sheets

    I have something similar I am struggling with (below novice).

    I have a master sheet and 102 'advisor named sheets'. The master sheet is updated daily with information (number and text) along 1 row in differnt columns. I would like when the advisors name is typed =joebloggs! for this whole row to be auto input on joebloggs sheet. There can be multiple of these entered daily for same person, so the information would need to populate on the next row so not to type over the previous entry.

    I can't use macros or anything like that so I need very basic explainations.

  11. #11
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: how to automatically update data in multiple sheets

    Please open a new thread and also upload a sample workbook with sample data in it.

  12. #12
    Registered User
    Join Date
    03-13-2014
    Location
    Athens, Greece
    MS-Off Ver
    Excel 2007
    Posts
    59

    Re: how to automatically update data in multiple sheets

    Oh my God!! It works!!!
    Thank you sktneer! So happy
    I decided! I want to learn macros!

  13. #13
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: how to automatically update data in multiple sheets

    Glad to help you. Thanks for the feedback.

+ 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. multiple data validation list want to update automatically excel 2010
    By ninny76 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2013, 11:57 PM
  2. [SOLVED] How to Automatically update data in other sheets in a workbook ?
    By joh46k in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-04-2013, 04:17 AM
  3. [SOLVED] Automatically populate data to multiple sheets
    By dfulmer in forum Excel General
    Replies: 6
    Last Post: 01-03-2013, 04:17 PM
  4. Update Data in Multiple Sheets From 1 Source Sheet
    By smfismfi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-11-2012, 04:17 PM
  5. Formulas to automatically update on multiple sheets
    By tone640 in forum Excel General
    Replies: 7
    Last Post: 06-30-2011, 04:44 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