skaterprez
New Member
- Joined
- Mar 9, 2009
- Messages
- 1
I am using Excel for Kpi's and I have one sheet that has 8 rows on sheet A that need to be referenced to one row on sheet B, The next 8 rows on Sheet A need to reference the next row on sheet B.... so on and so forth, excel is not noticing the pattern when I try to drag it down or using paste/paste special, Any Suggestions? There are 120 8 line segments and I dont want to manually input