Out Sourcing Pro’s Computing Tips and Free Software Tools Blog

If you are like me you keep track of lots of different data for various clients in Excel spreadsheets.  To save time I have setup most of my spreadsheets to automatically update information between sheets when ever possible.  This keeps me from having to manually enter data in multiple spreadsheets.  This both saves time and eliminates typos. 

Simply highlight the cell you want copied and click copy.  Go to the spreadsheet you want to paste to and right click on the cell where you want the linked data.  Click “Paste Special” and in the box that pops up click “Paste Link”.  Now each time you open the linked excel file it will automatically update itself!