Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy range based on input
Based on the value of one input cell, I want to copy a certain other range of
cells, pasting them into another area on the worksheet. When I change the value in the input cell, I want to copy a different range of cells into the same target range. I have several different values of the input cell that I would like to use for defining the copy range. Ideally, I would pick the value of the input cell from a list and use that to determine the copy range. I've been doing manual copy/paste and am tiring of it. Please help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy range based on input
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "Rengineer" wrote in message ... Based on the value of one input cell, I want to copy a certain other range of cells, pasting them into another area on the worksheet. When I change the value in the input cell, I want to copy a different range of cells into the same target range. I have several different values of the input cell that I would like to use for defining the copy range. Ideally, I would pick the value of the input cell from a list and use that to determine the copy range. I've been doing manual copy/paste and am tiring of it. Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy / Paste Specifc Row based on Input Box Value | Excel Programming | |||
specifying range based on input | Excel Programming | |||
print range based on cell input | Excel Programming | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
Macro to input formula in range based on another range | Excel Programming |