Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copy a specified name range
I have an estimating program file with 30+ worksheets in which I need to be
able to specify a specific range name from four available, then paste the data from a 5 column by 6 row range relating to that named range to a different worksheet to calculate overheads, field supervision, AFDC and profit using the specified range name (the four range names have different values). I think an 'IF' statement would work but I do not know how to tell it to choose the range and then paste it to the specific area on the 1st worksheet and be able to overwrite that data if another range name is used. I originally created this program in Lotus 1-2-3 using a macro. -- Lori |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
user input decides cell copy range | Excel Discussion (Misc queries) | |||
copy named range to powerpoint | Excel Worksheet Functions | |||
CheckBox Code to copy & paste range | Excel Discussion (Misc queries) | |||
help with range copy | Excel Discussion (Misc queries) | |||
reminder notifications in a column | Excel Discussion (Misc queries) |