Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repost:Synchronizing two sheets within the same workbook
Hi, I have two sheets within the same workbook, where I would like changes in one sheet to automatically also change the other sheet. It is not the entire sheet that should be synchronized, but rather a part of the sheet. To illustrate you might imagine a square in the middle of the sheet, which needs to change accordingly with the other sheet such that if a line is inserted in sheet 1, it is also inserted in sheet 2. The import external data function can actually synchronize between sheets, by updating on the refresh button, I would like a similar functionality within the workbook. I hope someone will know what to do here. Thx. in advance. Lars -- 50pingviner ------------------------------------------------------------------------ 50pingviner's Profile: http://www.excelforum.com/member.php...o&userid=29298 View this thread: http://www.excelforum.com/showthread...hreadid=505723 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repost:Synchronizing two sheets within the same workbook
Personally, I wouldn't do it.
You'll end up having to depend on macros and if macros are disabled (or events are disabled), your data will soon be out of sync--and you may not notice it. In fact, if something happens that you didn't program for, then you could be screwing something up. How about an alternative: Keep your live data in one worksheet--that's where the data entry will be done. Then select that range Edit|Copy Select the area on the other sheet where this should be displayed. Shift-Edit|Paste picture link The picture will update automatically when the original data changes (which is nice). But any calculations will need to point at the original range--not the picture. 50pingviner wrote: Hi, I have two sheets within the same workbook, where I would like changes in one sheet to automatically also change the other sheet. It is not the entire sheet that should be synchronized, but rather a part of the sheet. To illustrate you might imagine a square in the middle of the sheet, which needs to change accordingly with the other sheet such that if a line is inserted in sheet 1, it is also inserted in sheet 2. The import external data function can actually synchronize between sheets, by updating on the refresh button, I would like a similar functionality within the workbook. I hope someone will know what to do here. Thx. in advance. Lars -- 50pingviner ------------------------------------------------------------------------ 50pingviner's Profile: http://www.excelforum.com/member.php...o&userid=29298 View this thread: http://www.excelforum.com/showthread...hreadid=505723 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repost:Synchronizing two sheets within the same workbook
wow interesting.. thx. I didn't know that functionality. That might do the trick -- 50pingviner ------------------------------------------------------------------------ 50pingviner's Profile: http://www.excelforum.com/member.php...o&userid=29298 View this thread: http://www.excelforum.com/showthread...hreadid=505723 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
3 sheets in workbook, but visible only one? | Excel Discussion (Misc queries) | |||
Copy formatted in several sheets of a workbook | Excel Worksheet Functions | |||
Macros for Protect/Unprotect all sheets in a workbook | Excel Discussion (Misc queries) | |||
Sending sheets in workbook | Excel Discussion (Misc queries) | |||
Automatically copy selective sheets from one workbook to another | Excel Discussion (Misc queries) |