Putting together an excel file to be used as a tracker, where the first sheet will contain a list of names and a summary of the occurrences recorded on the other sheets, and a sheet for each month of the year for recording occurrences as the year goes on. How do I get the monthly sheets to reflect the master list of names? Right now if I need to add another name, inserting a row on the master list throws off the rest of the book that same row doesn't insert through the workbook taking everything out of alignment unless I go into each sheet individually and add a row and insert the formula to copy off the master list which is time consuming
Bookmarks