Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying the repeated data of the previous sheet to the next sheet | Excel Discussion (Misc queries) | |||
copying date from one sheet to another work sheet | Excel Worksheet Functions | |||
Dynamic column chart - copying from Sheet to Sheet. | Excel Discussion (Misc queries) | |||
Dynamic column chart - copying from Sheet to Sheet. | Charts and Charting in Excel | |||
2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions |