ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Automatic Cell Copy to other worksheets (https://www.excelbanter.com/excel-worksheet-functions/235055-automatic-cell-copy-other-worksheets.html)

sharice.g

Automatic Cell Copy to other worksheets
 
I made payment sheets for my cheerleaders in order to track orders and
payments made. I have about 30 different worksheets in this one workbook.
Workbook was excellent last time I used it. I havent had a problem in 3 yrs.
This time, even with application close and computer restart, every time I
enter information into one cell on one worksheet, it copies to all of the
worksheets and my formulas stopped calculating also. What to do?

Ron de Bruin

Automatic Cell Copy to other worksheets
 
Hi sharice

I think you see [Group] in the top blue bar, that means that you have more then one sheet selected.
Every change you make is for all the selected aheets

Right click on a sheet tab and choose "Ungroup Sheets"


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"sharice.g" wrote in message ...
I made payment sheets for my cheerleaders in order to track orders and
payments made. I have about 30 different worksheets in this one workbook.
Workbook was excellent last time I used it. I havent had a problem in 3 yrs.
This time, even with application close and computer restart, every time I
enter information into one cell on one worksheet, it copies to all of the
worksheets and my formulas stopped calculating also. What to do?



All times are GMT +1. The time now is 10:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com