close

Hi,
I have created a lot of drop down lists. When I right click it, select
Format Control the Insert Range looks up to a table I created - This works
OK. However, when I copy and paste them all into another new workbook the
Insert Range references the original workbook. I tried Find/Replace but it
doesn't pick up the Insert Range. How can I copy the drop down box and past
it with the references as they are, not linked to the previous workbook?

Thanks

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()