Srinivas, Oh WOW.. I don't think you're getting the power of this tool AT ALL!
Copy/paste makes a DUPLICATE of the data selected. The duplicate can then be modified so that it is then DIFFERENT than the original. This tool seems to act like a web-cam, in that it shows you what the area LOOKS like. If you change the color, font, or size of the original data, the PICTURE UPDATES! I actually added one of these to Sheet2 and had it point to Sheet1 (=Sheet1!$A1:$D30) went back to sheet1 and changed the color and font, returned to Sheet2 and it matched! One nice thing about this is that it can cover an area, thereby essentially "hiding" the area and providing rudimentary protection, but the cells beneath can be modified! Or, for testing purposes, say you have a Summary sheet that has formulas that calculate totals from the contents of another sheet. If you place one of these on the Data sheet, you can monitor the results while you're making changes to the Data without jumping back and forth to the other sheet! Haven't started using it yet, but oh.. the possibilities!!! THIS is the kind of stuff I joined the group for!!! thanks!!! Paul ________________________________ From: ddadmin2009 <ddadmin2...@gmail.com> To: excel-macros@googlegroups.com Sent: Tuesday, April 14, 2009 7:55:35 PM Subject: $$Excel-Macros$$ Re: Tip # 49 The Camera Tool in Excel Hi Ayush, I like the tool but how different is this from copy / paste. I really don't see any difference. Can you explain some real time scenarios where this is used more than copy / paste. Thanks, Srinivas. On 4/13/09, Ayush <jainayus...@gmail.com> wrote: Dear Members, A new tip of excel has been published on the blog . The title of the tip is "The Camera Tool in Excel". Please visit the below link for this tip. http://exceldailytip.blogspot.com/2009/04/tip-49-camera-tool-in-excel.html To see the archive of these Excel Tips, Go to: http://exceldailytip.blogspot.com Any comments would be highly appreciated. Please share these tips with your friends and associates. You are one of the 3800 members around the world. If you have any tips,please share it in the group. Thanks & Best Regards, Ayush Jain Group Manager -- http://funwithexcel.blogspot.com/ --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
