ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   changes to excel worksheet that is paged (https://www.excelbanter.com/new-users-excel/89753-changes-excel-worksheet-paged.html)

carole

changes to excel worksheet that is paged
 

Is there a way that I can make changes to an excel worksheet that is
paged into 12 months by changing one month and having changes follow
through to the others?


--
carole
------------------------------------------------------------------------
carole's Profile: http://www.excelforum.com/member.php...o&userid=34643
View this thread: http://www.excelforum.com/showthread...hreadid=544087


Ardus Petus

changes to excel worksheet that is paged
 
If you mean an Excel workbook with 12 worksheets:

Click 1st month's tab.
Keep Shift depressed
Click last month's tab

Now, your worksheets are grouped.
Everything you type in one worksheet is automatically copied to the 11
others.

HTH
--
AP

"carole" a écrit dans
le message de news: ...

Is there a way that I can make changes to an excel worksheet that is
paged into 12 months by changing one month and having changes follow
through to the others?


--
carole
------------------------------------------------------------------------
carole's Profile:
http://www.excelforum.com/member.php...o&userid=34643
View this thread: http://www.excelforum.com/showthread...hreadid=544087





All times are GMT +1. The time now is 02:38 PM.

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