I have an excel workbook in constant use, multiple sheets are added to it every day, the formatting of the sheets is exactly the same, only the content is different. The adding of the new sheets is done by a macro " Sheets("1").Copy After:=Sheets(Sheets.Count) " that makes a copy of the blank first sheet. I would like every sheet to have a cell that would sum the total of another cell form all the previous sheets depending on the date and initials, from other 2 cells. Also this TOTAL cell would be constantly there on all the sheets that will be added. In other words, there are 2 operators working on the same workbook, each day they create sheets with orders and collect certain amounts, the TOTAL cell should be able to calculate how much each operator has collected at the end of the day.Any help appreciated
Don’t have an account yet? Register yourself now and be a part of our community!