Excel 2007 : Moving a sheet with formulas and data validation to a new book

[dillyz]

Hi,
im quite the Excel noob and it might be easy for you, but i was just wondering if i can move a sheet in excel 2007 which is sort of like a quote form.

the first field is a data validation list and the remaining fields are vlookups according to whats been selected in the list for example

=VLOOKUP(A12,Info,2) etc

basically i want to have this quote sheet in a book by itself incase it accidently gets sent to people. All the information like prices etc are in different sheets in the workbook so ideally id like the Quote form totally by itself.

ive tried copying and pasting etc but the links don't move with the sheet.

its probably something easy but i couldnt work it out

Thanks for your time.

[arlu1201]

Have you tried right clicking on the sheet and selecting "move or copy" ? Then select the destination and do not check the box "Create a copy".

[dillyz]

yes, it moves the whole sheet to a new book but as soon as i close the other book the functions stop working.

[arlu1201]

Its better if you attach a sample of your files so we can troubleshoot easily and help you out.