View Single Post
  #3  
Old 12-02-2005, 04:51 PM
LaughingGravy's Avatar
LaughingGravy LaughingGravy is offline
Mmm.... Diesel.
 
Join Date: Oct 2003
Location: N. NJ
Posts: 434
Make sure the file you want to copy or transfer the sheets from is open as well as the intended destination. The intended destination Excel workbook should also already have it's own name, and not be just a new unnamed workbook.

Right click the sheet tab name that you want to move. You'll see an option to move...
Be sure whether you want a copy to the other named file or a move,deleting the sheet from its origin, before you complete the task.
Also, remember you can't have sheets with the same namein the same workbook. If you have macros that depend on formulas or values on other sheet tabs, depending on what you're doing, you may need to rename some sheet tabs, or edit the macros.

And while you're at it with the axe, chop me down a nice Christmas tree, OK?
Have fun.
__________________
85' 300D No inspection, No registration fees, Cheap insurance
"If my calculations are correct, when this baby hits 88 miles per hour, you're going to see some serious %$&^."
Reply With Quote