copy worksheet

I am using Excel 2003 with Win XP Pro. Many times I have copied worksheets from one workbook to another by right-clicking on the tab etc. However, all of a sudden, it's no longer possible. When I try to copy a worksheet from one workbook to another open workbook, the drop down destination list...

I have a rather large worksheet loaded with complex formulated cells. I need to copy the sheet and add it in other worksheets related to other dates. When I do this, within the formulated cell, there is a reference to the original worksheet i.e. October2010 example...

Hi all I have this template that I would like to copy, rename the copied sheet to tag no and name the tag no with the provided tag no. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I manage to get to the point of copy the sheet, rename and place the tag...

Hello, Consider my Thread Cherry popped! :laugh: I'm relatively new to the whole VB thing but seem to have picked it up quite quick by using Record and reading these forums & manuals and generally messing with it until it does what I want it to, but I can't seem to find what I'm looking for...

I currently have a database set up with one sheet named "Master" the Master sheet has all of my ranges, labels, headers, and format set how I would like all sheets within the workbook to be set. I would like to make this workbook "foolproof" seeing as how some of the people who may be using it...