| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
duplicate a range a specified number of times
How can I copy a range of cells and duplicate it the number of times
specified in a specific cell? For example cell A1 has 3 as the value. I want to copy A2:B5, and duplicate it three times (the number in cell A1) and paste side by side in the same sheet say beginning in cell A7. If cell A1 had a 7 as the value, I want to copy and duplicate the range 7 times etc. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the number of times a word is used in a range of cells | Excel Worksheet Functions | |||
| Need to Count the number of times a value occurs within a dt range | Excel Worksheet Functions | |||
| Duplicate rows a given number of times in Excel? | Excel Programming | |||
| Duplicate entry "x" number of times | Excel Discussion (Misc queries) | |||
| how do I count the number of times a word is repeated in a range? | Excel Discussion (Misc queries) | |||
Threaded Mode
