Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying the contents of a named range from one location to another
I have an named several named ranges of cells, each with serveral
rows/colomns and i want them to e displayed on my working area based on the combination i have selects from lists above where I want the named range to appear. I have tried using offset in my formula because the list will cover several rows/columns. Is there a way you can use a formual to bring copy the name range to my working area based on the condtions in my formaul. I am alraedy using the IF(ANd(.... in seevral other formulas to determine which lists to display in my po-up lists. I keep gettint the VALUE error in the cell I am entering the formula, so i think it is not recogonizing the fact that I do not want the named rrange contents to appear in the cell with the formula. Most likely I am not creating the offset with the name formula correctly. I have tried various combination of the following: IF((AND(A7=w10,A10=k7), offset(1,-5,1,1)the_name_ of_range_ here Any suggest would be appreciated. Thanks steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Named Range | Excel Worksheet Functions | |||
Hyperlink to Named Range Based On Cell Contents | Excel Worksheet Functions | |||
copying a named range | Excel Discussion (Misc queries) | |||
copying named range | Excel Discussion (Misc queries) | |||
Return entries from one named range based on the contents of another | Excel Worksheet Functions |