![]() |
Automatically adding lines
I have a number of worksheets with the same data. I would like to be able to
add a line to the "template worksheet" and have the same line added to all of the other worksheets. Is this possible. |
Automatically adding lines
Group all your worksheets together (right-click on a sheet tab and
choose Select All Sheets), then what you do on one (eg inserting a row) will happen on all the sheets. Don't forget to ungroup the sheets afterwards (right-click a sheet tab and choose Ungroup sheets). Hope this helps. Pete On Aug 27, 9:21*pm, Gordon wrote: I have a number of worksheets with the same data. *I would like to be able to add a line to the "template worksheet" and have the same line added to all of the other worksheets. *Is this possible. |
All times are GMT +1. The time now is 06:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com