Duplicated Values

  • Thread starter Thread starter Oliver Hunter
  • Start date Start date
O

Oliver Hunter

Hi,

I am using a workbook with multiple sheets to record
ticket sales for a Christmas Party. The first 5 sheets
contain employee information in identical format (there
are about 2000 employees).

The spreadsheet is being updated by 11 people over a
network using a mixture of versions of Excel from 97SR2 up
to XP. I have been using versions of Excel for over 10
years but have never encountered the following problem
before...

When a user enters a ticket number on one sheet it is
being duplicated into the same cell on the remaining
employee information sheets. I can't seem to find any
setting anywhere that would cause this and the only
formulas in the cells relate to the individual sheet.

Any help would be gratefully appreciated!

Kind regards,

Oliver
 
Are your sheets currently Grouped?
Right-click on one and see if the option comes up - Ungroup sheets, or the
like...
HTH
 
Thanks for your reply JMay!

When selecting all the sheets and right-clicking, 'ungroup
sheets' does indeed appear on the selection list. However,
even after selecting this it still appears when re-
selecting the sheets again and right-clicking. I shall
investigate to see if this has solved the problem.

Thanks again for your help!
 
It turns out that the problem was caused by one of the
users. They were selecting multiple sheets to search on
then typing values in whilst all the sheets were still
selected. The data was entered on to ALL selected sheets...
 
Back
Top