View Single Post
  #25  
Old 07-11-2005, 08:36 PM
New York Jet New York Jet is offline
Member
 
Join Date: Aug 2004
Location: Ohio
Posts: 30
Default Re: NEW Spreadsheet: 2.4b w/ Daily Summary

Here is how to copy and paste the daily summary in to your existing spreadsheet in 10 steps.

1. Open both your existing spreadsheet and the daily summary version.
2. In your existing spreadsheet, add a new worksheet, name it Daily Summary.
3. Select Tools, Macros, Microsoft Script Editor.
4. Expand the tree and highlight Daily Summary under the new version, then click View Code.
5. Select All (Ctrl-A) and copy (Ctrl-C).
6. Expand the tree and highlight Daily Summary under your existing spreadsheet.
7. Select All (Ctrl-A) and paste (Ctrl-V).
8. Close the Microsoft Script Editor.
9. In the new version, Daily Summary sheet, highlight cells A1 through Y368 and click the Special Paste button.
Do step 10 very carefully
10. In the existing version, Daily Summary sheet, highlight cells A1 through Y368.
Reply With Quote