Long time reader, first time poster...
Using Excel 2013 Professional on a Windows PC.
I have an Excel file with multiple sheets - each sheet is designed for individuals to make their own unique entries across a row and each row represents a complete entry. All the sheets in the workbook have identical columns.
I'm trying to create a Master Worksheet within the same file that captures entries from each of the other sheets as a live worksheet change event --- so when someone adds an entry to their individual sheet it adds the cell addresses for that row to the Master Sheet, and if they delete it, the row in the Master Sheet is cleared.
I have a WorkSheet change event code that does exactly that, the problem is that it only works for one sheet at a time. Using the same code in a different person's sheet only adds/clears the cell addresses to/from the Master Sheet if the entry is in a row that isn't the same as any other sheet (likely due to the "intersect" coding).
Is there a way to achieve this either using a variation of this current code or is there another better way to solve this.
File is attached and here's the code:
- The Master Sheet is called the "Dashboard" (Sheet3)
- "Rep sheet" is the individual person's sheet (ActiveSheet)
- Column "C" in each worksheet is the trigger for adding/subtracting a new entry
Any help is greatly appreciated.Please Login or Register to view this content.
Bookmarks