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.
Please try the attached. I've assumed that there will always be a value in the first column.
Last edited by mrice; 05-12-2009 at 03:58 AM.
Martin
Eighty Twenty Spreadsheet Automation http://homepage.ntlworld.com/martin.rice1/ for all your Excel customisation and consulting needs.
If my solution has saved you time and/or money, please consider donating to Cancer Research UK.
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!
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 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.
Martin
Eighty Twenty Spreadsheet Automation http://homepage.ntlworld.com/martin.rice1/ for all your Excel customisation and consulting needs.
If my solution has saved you time and/or money, please consider donating to Cancer Research UK.
Hello Champions!Originally Posted by mrice
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.
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.
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
I have the same need for this macro. Could you please tell me what you did to get this to work like it does?
if my file is at other source then what will be the code??????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
Why there is is no help for the query?
This website is a failure.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks