Closed Thread
Results 1 to 46 of 46

Auto-populate data to a master worksheet from other sheets in a shared workbook

  1. #1
    Registered User
    Join Date
    05-08-2009
    Location
    Scotland
    MS-Off Ver
    Excel 2000
    Posts
    3

    Auto-populate data to a master worksheet from other sheets in a shared workbook

    I have never really used VBA and so am completely stuck at this problem. I need to create a macro which auto-populates a master worksheet from the individual user sheets in a shared workbook.

    Sheet 1 is the master sheet "Team Stats". There will be an undetermined number of individual worksheets to accomodate new staff.

    Each worksheet will be identical, using columns A-I with row 1 having the headings:

    Date, Name, Reference, Value, Price, Age, Purchased?, Destination, Add. Products (the last 3 columns will have a drop-down list which will be used to enter data into the cell).

    There will be a varying number of rows in each of the individual sheets.

    If possible I would like the macro to run every time data is entered into one of the individual worksheets. If this is not then it would be fien to update every time the workbook is opened.

    If anyone can help it would really cut down the time I spend collating these stats every day!
    Last edited by JennyJAL; 05-12-2009 at 04:00 PM.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,966

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Please try the attached. I've assumed that there will always be a value in the first column.
    Attached Files Attached Files
    Last edited by mrice; 05-12-2009 at 03:58 AM.
    Martin

    If my solution has saved you time and/or money, please consider sponsoring my run in the 2020 London Marathon in aid of Cancer Research UK.

    https://uk.virginmoneygiving.com/MartinRice

  3. #3
    Registered User
    Join Date
    05-08-2009
    Location
    Scotland
    MS-Off Ver
    Excel 2000
    Posts
    3

    Smile Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    This seems to work perfectly, thank you for your help!

  4. #4
    Registered User
    Join Date
    07-02-2009
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    What was the macro that you used? I am having a similar problem with trying to link workbooks to one mastersheet. The template you sent works, but I am unable to save it in order to use it. Thanks!

  5. #5
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,966

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    I guess that you are using Excel 2007. If this is the case, you may need to save as a macro enabled workbook with a .xlsm extension.

  6. #6
    Registered User
    Join Date
    11-08-2011
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Quote Originally Posted by mrice View Post
    Please try the attached. I've assumed that there will always be a value in the first column.
    Hello Champions!

    I have tried to use the attached sheet. but it seems it is not solving my problem which is quite similar to this.

    1. I have Shared workbook with 10 user using individual W.SHEET.
    2. 1 master W.SHEET.

    what i want:
    1. After each user fill out the table in their individual sheet. that data(record) should goes to next available row in master sheet.
    2. That last updated master sheet should also get updated in all other open views. so the next person will done entering his data in table, then he can use the next available row without any conflict of changes.

  7. #7
    Registered User
    Join Date
    11-17-2011
    Location
    Wisconsin, USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    populate data from other worrksheet depending on the value selected in the dropdown

    Hi, I am Skhay.

    I am trying get a formulae for the requirement as mentioned:
    sheet1 A1 - name of the person, sheet1 b1 is the name of the month (provided as dropdown), sheet1 c1 is the expected result. In the same workbook, i have other worksheets named as the months (as displayed in sheet1 b1). In those worksheets, the same list of persons are listed and there is a numeric value against thier name in c1 of respective worksheet.

    Now i need to display the result in sheet1 c1 dynamically depending on the month selected in the dropdown (b1).
    For Example: sheet1 a1: XYZ, sheet1 b1: NOVEMBER, in the worksheet named NOVEMBER, against the person XYZ (in a1) there is a value 2277 (in c1). Now this value 2277 has to be dynamically populated in sheet1 c1.

    Basically formulae iam looking for is: if the value in the dropdown selected matches the worksheet name, then search for the person name in 'a' column and get the value from corresponding 'c' column.

  8. #8
    Registered User
    Join Date
    12-29-2011
    Location
    Saint John, Nb, Canada
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Hi I sooo hope you will read this ... THIS IS EXACTLY WHAT I NEED ... What is the Macro you used...
    I NEEDDD it thanks a bunch for the help

  9. #9
    Registered User
    Join Date
    11-03-2011
    Location
    Seattle, Washington
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Quote Originally Posted by jvalor View Post
    What was the macro that you used? I am having a similar problem with trying to link workbooks to one mastersheet. The template you sent works, but I am unable to save it in order to use it. Thanks!
    I have the same need for this macro. Could you please tell me what you did to get this to work like it does?

  10. #10
    Registered User
    Join Date
    12-17-2011
    Location
    mumbai
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Quote Originally Posted by mplagace View Post
    Hi I sooo hope you will read this ... THIS IS EXACTLY WHAT I NEED ... What is the Macro you used...
    I NEEDDD it thanks a bunch for the help
    if my file is at other source then what will be the code??????

  11. #11
    Registered User
    Join Date
    07-22-2013
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    8

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    I thank you for the above information as it is helping me put together a wedding invite list. My sheet 1 is "Master List" and the following sheets list out my family, my bride's family, my friends, etc. I was wondering if there was a way to make the sheet 1 "Master List" populate in alphabetical order? Thanks in advance.

  12. #12
    Registered User
    Join Date
    08-29-2013
    Location
    Brampton, On
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Quote Originally Posted by mrice View Post
    Please try the attached. I've assumed that there will always be a value in the first column.
    Hello

    This worked as well with what I needed to do, but I was wondering. I am using part numbers and QTY on 7 tabs ( different sections of macahines). The same part number could be used in the different sections (o-ring as an example) is there a way that when it auto populates on the master sheet that it can tally and provide a grand total if there are duplicates entered?

    Thank you

    Mel
    Last edited by Melyd; 08-29-2013 at 04:08 PM. Reason: deleting to start new thread

  13. #13
    Registered User
    Join Date
    12-06-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Quote Originally Posted by mrice View Post
    Please try the attached. I've assumed that there will always be a value in the first column.
    First time poster here and I know I am going to get flamed for resurrecting an old thread. This worked perfect for me also but how would I change the code to work with only certain worksheets. I have a lot of worksheets but I only need it to compile data from a couple.

    Please help me.

  14. #14
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,124

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    It appears that this thread has been hijacked by more than 4 people.
    Jason,Melyd and others need to start you won threads.
    Please read forum's rule.

  15. #15
    Registered User
    Join Date
    06-07-2014
    Posts
    8

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Hello mrice - I am responding to a very old post I found but your spreadsheet you attached is so close to what I am looking for thought you might be able to help

    In your spreadsheet the individual tabs auto populated the Master sheet.

    My master Sheet has multiple columns / headers labelled across the top like below

    Company Contact Industry Sector Sales Stage Priority Country Competitor Held Account Comments


    I have 25 other identical spreadsheet tabs labelled by individual countries - all the countries in Africa

    I want to go to the master sheet, select a country from a dropdown menu, and then start filling in all the other columns on the master and have that information auto populate the individual country sheet with the same information. If I select Angola on master and enter all my data on the master, the Angola sheet auto populates and so on with each country I select on the master.

    Any advice

  16. #16
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,966

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    I expect that the moderators will be asking you to start a new thread on this one, it seems to have been popular over the years. Can you do so and I'll look out for it if someone else doesn't provide a solution before me.

  17. #17
    Registered User
    Join Date
    03-10-2015
    Location
    CA, USA
    MS-Off Ver
    2010
    Posts
    1

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    For anyone still looking, the Macro was embedded in the first tab:

    Please Login or Register  to view this content.

  18. #18
    Registered User
    Join Date
    07-25-2015
    Location
    1349
    MS-Off Ver
    2010
    Posts
    1

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Hi..i downloaded this file but ..only plain Data..there is nothing is changed when i entered data in first sheet..

  19. #19
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,966

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    You might need a line like

    Please Login or Register  to view this content.

  20. #20
    Registered User
    Join Date
    08-11-2015
    Location
    England
    MS-Off Ver
    2007
    Posts
    9

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Great Macro. Does anyone know how I can also add info/date to the team stats sheet/ master sheet and it also populates the relevant work sheets with that information ( a two way updating macro between sheets so to speak)

    Many thanks

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

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    VBA Magic, welcome to the forum

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    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

  22. #22
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Hi VBA Magic....

    Quote Originally Posted by FDibbins View Post
    VBA Magic, welcome to the forum ........ -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread. .......
    . And if you do that and PM ( Private Message ) ** me and give me a llink to the new Thread, then I will do it for you tomorrow.. but only if you give me somehow
    Good before and after “ Pictures “ as well as your explanations so i can see exactly what you want..

    . The Before or Befores, should look just as it / they does before running of any macro.
    .
    . The After or Afters, should be hand filled by you so that it they / looks exactly as you want it to After running of any macro, based on the actual sample data in the Before / or Befores
    . Make sure there is just enough data to demonstrate your need. Remember to desensitize the data if necessary.

    To do that, try to
    . 1 ) use the Forum Tools in my signature to produce screen shots we can copy to a spreadsheet ( NO IMAGES ! )
    . 2 ) Post Files
    . 2 a) To Attach a sample workbook:
    View Pic
    http://www.excelforum.com/members/da...ch-a-file.html
    http://tinyurl.com/oenwprw
    . 2 b) Send over a file sharing site, such as this free thing
    Box Net,
    https://www.box.com/
    http://tinyurl.com/7chr7u8
    . Remember to select Share and give the link / links they give.
    . 3 c) Only as a last resort, P.M. me and i will reply with my Email Addressee so you can send me a file
    ** To PM me, click on my name in the left hand margin when you are logged in, the rest should be obvious.

    Alan
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

  23. #23
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,957

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Alan,

    he's started a new thread of his own now.

    Pete

  24. #24
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Quote Originally Posted by Pete_UK View Post
    Alan,

    he's started a new thread of his own now.

    Pete
    OK, found it, thanks.
    Alan

  25. #25
    Registered User
    Join Date
    03-16-2016
    Location
    North Hollywood
    MS-Off Ver
    2013
    Posts
    1

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    It seems though if you delete the data on the other sheets it drops off the Team Stats sheet.
    Is there any way to keep what was entered initially and have it keep adding?

    Referencing your Book1 file. mrice
    Last edited by jchung369; 03-17-2016 at 10:59 AM.

  26. #26
    Registered User
    Join Date
    04-19-2015
    Location
    USA
    MS-Off Ver
    2011
    Posts
    4

    Post Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Hey All-
    Can anyone help me figure out what is wrong with my Macro in the attached workbook.
    I have sales reps that are populating their own sheets and I want those result to populate the master.
    I have an error and I cant figure out how to solve it.
    I am totally new at this so its a copied Macro, any help would be appreciated.
    Thanks
    Dan
    Attached Files Attached Files

  27. #27
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,541

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    dshamp,
    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Ben Van Johnson

  28. #28
    Registered User
    Join Date
    08-24-2016
    Location
    Sacramento, California
    MS-Off Ver
    2010
    Posts
    8

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    I tried applying same code to my "Master" sheet and get a debug error.

    Highlighted: "For Each Sheet In Me.Parent.Sheets"

    My Master sheets also has added columns that two of my other sheets don't have. Could this be the issue?

  29. #29
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,541

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Simple_man916, did you see post #27?
    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

  30. #30
    Registered User
    Join Date
    07-25-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    6

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Hi,

    I am trying to consolidate different workbook in a one master file, the code used earlier one but it's not work.

    the row count is not fixed it is variable.

    thanks in advance.
    Himanshu

  31. #31
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Another one that needs the rules spelt out in Hindi, Lol. :)

    Hi Himanshuktw
    Welcome to the Forum

    The original subject of this Thread is automatically consolidating data from worksheets in a single Workbook. The data from all but a Master Worksheet is consolidated into the Master Worksheet automatically.

    You appear to be asking a different question related to consolidating data from a number of workbooks into a main Workbook.

    If this is the case, then you need to start a new Thread in the VBA Sub Forum:
    http://www.excelforum.com/excel-programming-vba-macros/
    Start a new Thread there:
    https://www.excelforum.com/newthread...=newthread&f=7

    It would help a lot if you give us a small amount of mock up data. Keep it representative but not necessary real data.
    Show us
    _ 1. the start situation. The “Before”
    _ 2. Give us an “After”. This “After” should be hand made by you to look exactly as you what the macro to produce for you based on your “Before”

    _.___________________________-

    Just for quick info regarding finding the last row…:
    Quote Originally Posted by Himanshuktw View Post
    the code used earlier one but it's not work.
    the row count is not fixed it is variable......
    There are many ways to determine the last row in a worksheet.
    For example:
    Please Login or Register  to view this content.
    "MySheetName" is your Worksheet name

    LastRow is an Integer Number, in this case greater or equal to one. The number returned from the above code, LastRow, is determined by looking “back Up” from the last cell in column 1 (.Item(Rows.Count, 1) ), until the last cell with data in it is found. This cell which is retuned from the .End(xlUp) process of “looking back up”, then has the .Row Property applied to it which returns the Row number of that cell.

    If your last data was in column 2 , then the code line would be:
    Please Login or Register  to view this content.
    _.____________________________
    _............................................

    Please, also, if you get time, take some time before posting to read the Forum Rules here
    http://www.excelforum.com/forum-rule...rum-rules.html
    http://www.excelforum.com/forums-rules/
    http://www.excelforum.com/developmen...ml#post4606484
    It is usually worth it in the long run.


    Thanks
    Alan

  32. #32
    Registered User
    Join Date
    07-25-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    6

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Hi,

    Thanks for updating.

    My question is here, i need a code for consolidate multiple workbook from sheet2 in one master file.

    All the files save in a same folder.

    Thanks

    Himanshu

  33. #33
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,541

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Himanshuktw,
    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Last edited by protonLeah; 07-27-2017 at 01:10 AM.

  34. #34
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Himanshuktw,

    I think many of us can easilly help you,

    But:
    You must start a new Thread:
    Ask your question here: https://www.excelforum.com/newthread...=newthread&f=7 ( Post New Thread )

    Also, give us sample data to show us what you have and what you want the macro to do

    Alan
    Last edited by Doc.AElstein; 07-27-2017 at 04:56 AM.

  35. #35
    Registered User
    Join Date
    08-24-2017
    Location
    Bakersfield
    MS-Off Ver
    MSOFFICE2016
    Posts
    4

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Hello all! Hope I'm not hijacking as it's definitely not my intent.

    This thread describes exactly what I need! I realize it's an old post however, and I am currently running EXCEL 2010.

    I would be happy to share my file as I have tired of entering data manually. I will be adding more sheets and they will all have the same format.

    If anyone can help, I would greatly appreciate it!

  36. #36
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,861

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    You are hijacking!!! Best to start your own thread. Also, please do attach a sample file. I'll not be helping you as I don't do VBA. But someone will.
    Glenn



  37. #37
    Registered User
    Join Date
    08-24-2017
    Location
    Bakersfield
    MS-Off Ver
    MSOFFICE2016
    Posts
    4

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Thank you much and my apologies.

    I will do that, thanks again!!

  38. #38
    Registered User
    Join Date
    12-18-2017
    Location
    colorado
    MS-Off Ver
    ms office for mac
    Posts
    1

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Private Sub Worksheet_Activate()
    Dim Sheet As Worksheet
    For Each Sheet In Me.Parent.Sheets
    If Sheet.Name <> Me.Name Then
    If Sheet.Cells(Rows.Count, 1).End(xlUp).Row <> 1 Then
    Sheet.Range(Sheet.Cells(2, 1), Sheet.Cells(Sheet.Cells(Rows.Count, 1).End(xlUp).Row, 10)).Copy Destination:=Me.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)

    End If
    Else
    Me.Range(Cells(2, 1), Cells(Rows.Count, 10)).Clear
    End If
    Next Sheet
    End Sub

  39. #39
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,541

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    gumshed, You are hijacking!!!
    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

  40. #40
    Registered User
    Join Date
    09-09-2020
    Location
    Columbus, Ohio
    MS-Off Ver
    2013
    Posts
    1

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    This is great but how do I extend the code so I can include additional columns and rows in each worksheet?

  41. #41
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,957

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Do you not understand the comments above about hijacking? Please start your own new thread, referring back to this one if you think it is relevant.

    Pete

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

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Quote Originally Posted by kevin65811 View Post
    This is great but how do I extend the code so I can include additional columns and rows in each worksheet?
    how can you NOT have seen all the posts above telling others to start their own thread??? is there something special about you that you feel this instruction should not apply to you?

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

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    To ALL others that would ask questions regarding this thread...DONT!! Start your own thread (and READ our rules!)

  44. #44
    Registered User
    Join Date
    08-18-2021
    Location
    Saudi
    MS-Off Ver
    Microsoft office professional plus 2016
    Posts
    4

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Can you help me with my sheet too? I have the same request, not sure what code to put in or how

  45. #45
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    53,200

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    Administrative Note:

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking.

    Please continue here in your own thread: https://www.excelforum.com/excel-pro...ter-sheet.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

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

    Re: Auto-populate data to a master worksheet from other sheets in a shared workbook

    I am SOOOOO tempted to just ban the op from post #44...htf can they not have read what I posted???

Closed Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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