Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Drop Down List Then Creating Saved File (with formulas intact)
Hi Guys,
I've got a problem that I can't see an obviously easy answer too (although I'm sure you'll prove me wrong!). I have a large spreadsheet that I want to break down using the drop down list feature. I need each file to show the contents of the drop down list for that option only. This I can do manually which is ok (albeit it REAL slow), however, the problem is that when I copy and paste the selected items into a new worksheet the formulas are all converted to values. Does anyone have any idas of how I can get around this (or at least speed the process up)? Any help is greatly appreciated. Best Regards, CalumMurdo Kennedy GB-1-1563 www.taekwondo.freeserve.co.uk |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating nested formulas from drop down box | Excel Discussion (Misc queries) | |||
Help Creating a Drop Down List from a List in another worksheet | Excel Discussion (Misc queries) | |||
How do I copy worksheets with drop-down menus intact? | Excel Worksheet Functions | |||
Creating a drop down list from another drop down | Excel Discussion (Misc queries) | |||
Formulas not updating until file is saved | Excel Discussion (Misc queries) |