S
S.C
I do a monthly stat sheet that lists a member number in column B, in column
D is the total number of work done. Each month the list has the same data in
column B and D. But Column B may have other people added or subtracted each
month.
The common worksheet has everyone listed in column B.
Each month I would add a new worksheet for the previous month, Is there a
formula that will allow me to reference the previous month by column B and
place column D data in a cell that would reference the new worksheet? Column
D data would move each month to a new cell on the common worksheet.
I would end up with 13 worksheets, one for each month and then a common
sheet that would add the totals of each persons data by month.
End result would be
A B C
ID Jan Feb
11 0 15
12
13 11 6
14 2
15 7 7
16 22 17
17 5 10
Thanks for any advise or suggestions
Steve
D is the total number of work done. Each month the list has the same data in
column B and D. But Column B may have other people added or subtracted each
month.
The common worksheet has everyone listed in column B.
Each month I would add a new worksheet for the previous month, Is there a
formula that will allow me to reference the previous month by column B and
place column D data in a cell that would reference the new worksheet? Column
D data would move each month to a new cell on the common worksheet.
I would end up with 13 worksheets, one for each month and then a common
sheet that would add the totals of each persons data by month.
End result would be
A B C
ID Jan Feb
11 0 15
12
13 11 6
14 2
15 7 7
16 22 17
17 5 10
Thanks for any advise or suggestions
Steve