Archive of Mr Excel Message Board
Back to Dates in Excel archive index
Back to archive home
Repeating patterns of mutiple formulas by rowsPosted by Marty on April 13, 2001 9:03 AM
I have a situation where I am trying to have line 1 in a result tab look at line 1 in a data tab. Then line 2 in the result tab look again at line 1 in the data tab. Then, have line 3 in the results tab look at line 1 again in the data tab.
After that, line 4 in the results tab would start to repeat the above pattern. I try to copy automatically by clicking and dragging downwards but have yet to find the proper way to make the pattern repeat correctly.
Re: Repeating patterns of mutiple formulas by rowsPosted by Mark W. on April 13, 2001 9:40 AM
Marty, do you want rows 4:6 of your results worksheet
to refer to row 2:2 of your data worksheet?
Re: Repeating patterns of mutiple formulas by rowsPosted by steve on April 13, 2001 10:30 AM
sounds like you just need to anchor down the 1 by using a dollor sign? not exactly sure what you need but this make the 1 stay the same during copying. =A$1
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.