#1
|
|||
|
|||
Best way to automate combining of multiple workbook data on trigger?
There are a lot of data which I require from my team of 24 pax on a weekly basis. There are standard columns from A to T.
What happens now is that when 1 person goes in to update the data, he - runs the risk of corrupting the master data - locks the workbook and can't let other people input their data (we can't use office 2016/365 here) on the shared drive I'm thinking to let each member have their own workbook with the same template, and run a macro (or using some other trick) to auto-combine their entries within a table across 24 workbooks. Is that possible? Ideally, there should be no hardcoding but if not, happy to consider other options too. **********************************************- Separately, I have created a few Pivotcharts but it's weird that the default is I can only display in Quarters or Years, but not Months. Even with an additional Timeline bar, the charts will only display in Q or Y, but not M. What is wrong and what can I do to rectify the issue? Thanks! |
#2
|
||||
|
||||
You will find inspiration at http://www.rondebruin.nl/win/addins/rdbmerge.htm
or http://www.rondebruin.nl/win/section3.htm It's always best to start one thread for each question you have, otherwise members could skip the second question after answering the first
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
thanks for sharing! unfortunately, I'm unable to use add-ons at my workplace.
For the VBA option, is there any way to detect changes to values within each workbook's rows, so they can be updated in the Master file accordingly? The current one simply adds whatever is available within individual workbooks. Another implication is that if individuals make changes to their own workbooks, I won't be able to tell unless I read through each entry manually. Is there any checking mechanism I can put in place then? |
#4
|
|||
|
|||
any advice pls?
|
#5
|
||||
|
||||
I moved the thread to the programming forum. See what the Gurus there can do
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Summing data from multiple worksheets in a workbook and placing into another worksheet | safrac | Excel | 17 | 10-04-2022 12:21 PM |
data entered in one workbook should be updated in other relevant workbook based on the date | vedha | Excel | 0 | 04-24-2015 08:45 PM |
Combining 2 workbooks into 1 workbook with TWO sheets | dguenther | Excel | 1 | 10-06-2011 03:25 AM |
macro to transfer data from one workbook to another workbook | virsojour | Excel Programming | 5 | 02-01-2011 08:58 PM |
How do I merge data from one sheet in a workbook out into multiple sheets | nolesca | Excel | 4 | 06-07-2010 08:13 AM |