Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list - copy from different workbook - Name duplication e
I have a workbook which is one worksheet to be used and distributed as a
template, filled out, and copied back into the master workbook which contains many identical templates on differently named worksheets. Each template corresponds to one account in the master workbook. about 100 cells on that template is in drop-down validation form. The Master and the template each have the same validation rules, named lists, etc. The problem is that when I copy the template over the corresponding worksheet in the master, I get the " a formula or sheet you want to copy contains the name "Brand" which already exists on the destination worksheet . .. ." I know what that error means, and since all of the names and corresponding values are the same in both workbooks, I want to answer yes - use the name from the destination sheet. However, the error pops up 100 times - once for each affected cell. There is no "yes to all" option here. Is there a way I can by-pass this error or have Excel choose yes in each instance? Pasting values only is not an option, because other values on the same sheet must be preserved as formulae. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto updating list | Excel Worksheet Functions | |||
Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
Can not copy a worksheet to another workbook | Excel Discussion (Misc queries) | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Refer to seperate workbook for validation list for drop downs? | Excel Discussion (Misc queries) |