insert lines
I am trying to do the following: If I add a line in Sheet 1, I want the same line with the same infos added automatically in Sheet 2. Is there any way to do that? Thanks for advice! Alex -- abunge ------------------------------------------------------------------------ abunge's Profile: http://www.excelforum.com/member.php...o&userid=35079 View this thread: http://www.excelforum.com/showthread...hreadid=548275 |
insert lines
Hi I assume when u mean add lines u mean putting in cell entries? You can do it by grouping the worksheets when u enter data. Click on the sheet tab, like say Sheet 1, den ctrl click on other Sheets like Sheet 2 to group them. Alternatively, you can use shift to select a range of worksheets on the sheet tab. Then, enter any data in Sheet 1, and the change will reflect on all sheets grouped. To upgroup them, just right click on the sheet tab and press ungroup. Drawing like lines or shapes cannot be added to multiple sheets automatically, so you have to do it manually. ^^ -- KellTainer ------------------------------------------------------------------------ KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322 View this thread: http://www.excelforum.com/showthread...hreadid=548275 |
insert lines
Great, thanks a lot! I am trying to handle loads of data on different sheets, and this makes adding changes much easier. I knew there was some sort of easy solution... Thanks Alex -- abunge ------------------------------------------------------------------------ abunge's Profile: http://www.excelforum.com/member.php...o&userid=35079 View this thread: http://www.excelforum.com/showthread...hreadid=548275 |
All times are GMT +1. The time now is 04:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com