LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 18
Default copying a sheet - getting an error

excel 2007:
I have a workbook that has one sheet in it. It was started from using the
personal monthly budget template provided with excel. I inserted this
template and then edited it to my liking. It works great. No macros or vb
script, simply uses tables, formulas, and conditional formatting.
The problem is when I try to copy this sheet into the same workbook the
first copy works fine, then I try to make another copy and I get a warning
dialog box that says: the sheet you want to copy contains the name 'payment
date', which already exists on the destination worksheet. Do you want to use
this version of the name?

I dont understand what it's asking here....
1) I do not have the name payment_date anywhere in the sheet or in any
formula on the sheet.
2) even if I did the message makes no sense as of course the destination
sheet is going to have that name because its a copy of another sheet, it
should be the same with all the same names, so of course the destination
would have the same name.
3) why does the first copy of the sheet give no warning message at all, but
subsequent copies does gives the warning message.

Can someone explain this message, tell me why I'm getting it, and how to get
excel to stop warning me.
Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying the repeated data of the previous sheet to the next sheet Sasikiran Excel Discussion (Misc queries) 1 September 25th 07 03:18 PM
copying date from one sheet to another work sheet Jay Excel Worksheet Functions 13 September 25th 06 10:56 PM
Dynamic column chart - copying from Sheet to Sheet. Marko Pinteric Excel Discussion (Misc queries) 1 April 10th 06 12:57 PM
Dynamic column chart - copying from Sheet to Sheet. Marko Pinteric Charts and Charting in Excel 1 April 10th 06 12:57 PM
2 questions, copying data from sheet to sheet and assigning macro Boris Excel Worksheet Functions 0 December 16th 04 06:11 PM


All times are GMT +1. The time now is 11:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"