dance7salsa7
New Member
- Joined
- Jan 22, 2010
- Messages
- 2
****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5CMartin%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> Microsoft Excel – How to copy cells to a different worksheet on every nth row.
I have an interesting problem. It is probably simple, but I can’t figure it out.
<o
> </o>
I have a list of cells (about 10 columns across and over thousand rows, soon to be expanding)
A1-A10 and down
These are my headings and main input cells (let’s call this Summary Sheet)
<o> </o>
I need these cells copied and preferably linked to the adjacent worksheet (Detailed Sheet), but in such a way that each cell (or 10 cell across) is copied on every 20 th line.
<o> </o>
At times I will be adding and deleting rows from the Summary Sheet. Therefore I would love to be able to use autofill or some feature like that in the Detailed Sheet. After I update my Summary Sheet and could then update Detailed Sheet by autofilling the formulas down.
<o> </o>
<o> </o>
More detailed info:
Each row to which these cells are copied becomes a heading row for each 20 line module. The 19 rows below the copied headings remains empty and detailed calculations are done on the 19 rows further right. Each section is an identical module with many detailed calculations and the results on the 1 row in each module.
Presently I only use the Detailed Sheet and it is very time consuming to add or remove modules and their headings.
<o> </o>
<o> </o>
<o> </o>
Summary Sheet
A B C D
1 #A1 #B1 #C1 …
2 #A2 #B2 #C2 …
3 #A3 #B3 #C3 …
<o> </o>
Detailed Sheet
A B C D
1 #A1 #B1 #C1 …
… 19 empty lines
21 #A2 #B2 #C2 …
… 19 empty lines
31 #A3 #B3 #C3 …
… 19 empty lines
<o> </o>
Thanks for any answers.
Martin
I have an interesting problem. It is probably simple, but I can’t figure it out.
<o
> </o>I have a list of cells (about 10 columns across and over thousand rows, soon to be expanding)
A1-A10 and down
These are my headings and main input cells (let’s call this Summary Sheet)
<o
> </o>I need these cells copied and preferably linked to the adjacent worksheet (Detailed Sheet), but in such a way that each cell (or 10 cell across) is copied on every 20 th line.
<o
> </o>At times I will be adding and deleting rows from the Summary Sheet. Therefore I would love to be able to use autofill or some feature like that in the Detailed Sheet. After I update my Summary Sheet and could then update Detailed Sheet by autofilling the formulas down.
<o
> </o><o
> </o>More detailed info:
Each row to which these cells are copied becomes a heading row for each 20 line module. The 19 rows below the copied headings remains empty and detailed calculations are done on the 19 rows further right. Each section is an identical module with many detailed calculations and the results on the 1 row in each module.
Presently I only use the Detailed Sheet and it is very time consuming to add or remove modules and their headings.
<o
> </o><o
> </o><o
> </o>Summary Sheet
A B C D
1 #A1 #B1 #C1 …
2 #A2 #B2 #C2 …
3 #A3 #B3 #C3 …
<o
> </o>Detailed Sheet
A B C D
1 #A1 #B1 #C1 …
… 19 empty lines
21 #A2 #B2 #C2 …
… 19 empty lines
31 #A3 #B3 #C3 …
… 19 empty lines
<o
> </o>Thanks for any answers.
Martin
