Hi
Impossible to speculate without seeing the code.
Open up the VB Editor using Alt+F11. In the left hand VBA Project
window click on ThisWorkbook for your Excel file (Project). Are any
macros present in the right hand window starting with Private Sub? It
looks like your code is running a macro called SheetCalculate or
SheetChange. Resend this email with any Private Sub macros pasted in
too. Send it as a new mail as a lot of people won't open mails with 2
or more contributors (as they take them to be solved).
regards
Paul


On Jul 21, 3:00*pm, wrote:
Dear experts
I have inherited an excel spreadsheet which details staff attendance
over a six month period, I have made some adjustments to include self
calculating numbers of staff on duty etc. The sheet has a monthly drop
down list which allows you to select the next month and go straight to
that sheet (visual basic I think). The issue I have is for each row
(allocated to a member of Staff) when I input attendance or absence
from a validated list, it copies this into the corresponding cell in
all monthly sheets. Obviously I don’t want that to happen. Any
assistance welcome.