Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Repeat Text
In cell C2 I have a text entry, Installation Complete XA3C.
I need to have repeat every 6 rows, in row 8, 14, 20,etc. Not sure how far down it needs to go, as that will be determined as the process is ongoing. Any way to automate entering this entry for possibly hundreds of rows? Thanks Paul |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Repeat Text
You could add this formula to a blank cell:
=MOD(ROW()+4,6) and copy down the column. Apply a filter to this column and select the value 0, which will display rows 2, 8, 14, 20 etc. Then <copy cell C2 and <paste to the other cells in column C which are visible, however many you feel you need. You can then delete the helper column (and the filter with it). Hope this helps. Pete PA wrote: In cell C2 I have a text entry, Installation Complete XA3C. I need to have repeat every 6 rows, in row 8, 14, 20,etc. Not sure how far down it needs to go, as that will be determined as the process is ongoing. Any way to automate entering this entry for possibly hundreds of rows? Thanks Paul |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Repeat Text
Many thanks, you just saved me hours of work.
"Pete_UK" wrote: You could add this formula to a blank cell: =MOD(ROW()+4,6) and copy down the column. Apply a filter to this column and select the value 0, which will display rows 2, 8, 14, 20 etc. Then <copy cell C2 and <paste to the other cells in column C which are visible, however many you feel you need. You can then delete the helper column (and the filter with it). Hope this helps. Pete PA wrote: In cell C2 I have a text entry, Installation Complete XA3C. I need to have repeat every 6 rows, in row 8, 14, 20,etc. Not sure how far down it needs to go, as that will be determined as the process is ongoing. Any way to automate entering this entry for possibly hundreds of rows? Thanks Paul |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Repeat Text
Perhaps easier is to simply enter your text into C2 and C8.
Then select C2 to C13. Click the 'fill handle' of the selection, and drag down to copy as needed. And you're done! -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "PA" wrote in message ... Many thanks, you just saved me hours of work. "Pete_UK" wrote: You could add this formula to a blank cell: =MOD(ROW()+4,6) and copy down the column. Apply a filter to this column and select the value 0, which will display rows 2, 8, 14, 20 etc. Then <copy cell C2 and <paste to the other cells in column C which are visible, however many you feel you need. You can then delete the helper column (and the filter with it). Hope this helps. Pete PA wrote: In cell C2 I have a text entry, Installation Complete XA3C. I need to have repeat every 6 rows, in row 8, 14, 20,etc. Not sure how far down it needs to go, as that will be determined as the process is ongoing. Any way to automate entering this entry for possibly hundreds of rows? Thanks Paul |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Repeat Text
You're welcome.
Pete PA wrote: Many thanks, you just saved me hours of work. "Pete_UK" wrote: You could add this formula to a blank cell: =MOD(ROW()+4,6) and copy down the column. Apply a filter to this column and select the value 0, which will display rows 2, 8, 14, 20 etc. Then <copy cell C2 and <paste to the other cells in column C which are visible, however many you feel you need. You can then delete the helper column (and the filter with it). Hope this helps. Pete PA wrote: In cell C2 I have a text entry, Installation Complete XA3C. I need to have repeat every 6 rows, in row 8, 14, 20,etc. Not sure how far down it needs to go, as that will be determined as the process is ongoing. Any way to automate entering this entry for possibly hundreds of rows? Thanks Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to repeat text on sheets in excel | Excel Worksheet Functions | |||
Match, Copy, Merge, Delete and Repeat... MVP's this one's for you. | Excel Discussion (Misc queries) | |||
How I can print full text bigger than column, in repeat column | Excel Discussion (Misc queries) | |||
in excel can one repeat the text from a the last used column cell. | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |