| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
repeat range of data values down through end of table
Hi -
I would like to repeat of range/pattern of data values (cells B2 through C5) down through columns B and C until the end of table....For instance the values in B2 through C5 would be repeated again starting on next blank row which would be B6 through C9 and so on... Thank you! Pia |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
repeat range of data values down through end of table
Range("B2:")C5.Copy For RowCount = 6 to 200 step 4 Range("B" & RowCount).Paste Next RowCount "PiaD" wrote: Hi - I would like to repeat of range/pattern of data values (cells B2 through C5) down through columns B and C until the end of table....For instance the values in B2 through C5 would be repeated again starting on next blank row which would be B6 through C9 and so on... Thank you! Pia |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
repeat range of data values down through end of table
I made a typo
Range("B2:C5").Copy For RowCount = 6 to 200 step 4 Range("B" & RowCount).Paste Next RowCount "PiaD" wrote: Hi - I would like to repeat of range/pattern of data values (cells B2 through C5) down through columns B and C until the end of table....For instance the values in B2 through C5 would be repeated again starting on next blank row which would be B6 through C9 and so on... Thank you! Pia |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
repeat range of data values down through end of table
Thank you for the response! I will give it a try.
"Joel" wrote: I made a typo Range("B2:C5").Copy For RowCount = 6 to 200 step 4 Range("B" & RowCount).Paste Next RowCount "PiaD" wrote: Hi - I would like to repeat of range/pattern of data values (cells B2 through C5) down through columns B and C until the end of table....For instance the values in B2 through C5 would be repeated again starting on next blank row which would be B6 through C9 and so on... Thank you! Pia |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting data from one table/range to another table/range | Excel Discussion (Misc queries) | |||
| How do I get a Pivot Table to repeat the values in the columns? | Excel Discussion (Misc queries) | |||
| Pivot table - *repeat* duplicate values | Excel Discussion (Misc queries) | |||
| Pivot Table - Repeat row data | Excel Discussion (Misc queries) | |||
| how to pick from a range of table values | Excel Worksheet Functions | |||
Linear Mode
