undemane
Board Regular
- Joined
- Nov 19, 2007
- Messages
- 75
A B C D E F G H I J ..................GW
----------------------------------------------------------------------------
Program BuildDur Hours 1/10 1/17 1/24 1/31 2/7 2/14.................
Prog 1 1 162 0 0 0 0 1 1...........
WkHrs 0 0 0 0 162 162.......
MonthHrs 0 324
Prog 2 1 200 0 0 0 0 1 1...........
WkHrs 0 0 0 0 200 200.......
MonthHrs 0 400
.
.
data ends in row781.
-------------------------------------------------------------------------
The data "Prog1" is in row 212, "Wk Hrs" in row 213, MonthHrs in row 214. "Prog 2" is in row 215, and so on. I want to create a table in another sheet to look like I've shown below:
Program Build Dur Hours Jan-10 Feb-10 Mar-10......................
Prog1 1 162 0 324 0 .......
Prog2 1 162 0 400 0 .......
Is there an easy way to create the table in Sheet2? How do I make the formula in Sheet 2 look at E214, then skip 3 rows to look at Prog 2 in E217 and so on?
Thank you!
----------------------------------------------------------------------------
Program BuildDur Hours 1/10 1/17 1/24 1/31 2/7 2/14.................
Prog 1 1 162 0 0 0 0 1 1...........
WkHrs 0 0 0 0 162 162.......
MonthHrs 0 324
Prog 2 1 200 0 0 0 0 1 1...........
WkHrs 0 0 0 0 200 200.......
MonthHrs 0 400
.
.
data ends in row781.
-------------------------------------------------------------------------
The data "Prog1" is in row 212, "Wk Hrs" in row 213, MonthHrs in row 214. "Prog 2" is in row 215, and so on. I want to create a table in another sheet to look like I've shown below:
Program Build Dur Hours Jan-10 Feb-10 Mar-10......................
Prog1 1 162 0 324 0 .......
Prog2 1 162 0 400 0 .......
Is there an easy way to create the table in Sheet2? How do I make the formula in Sheet 2 look at E214, then skip 3 rows to look at Prog 2 in E217 and so on?
Thank you!