Seven teams have their productivity statistics logged daily. The person who
entered the data only entered the date once for the first team, then skipped
seven lines and entered the next date. I am trying to do a pivot chart/table
for each month's data, and the blank lines in the date column are giving me
trouble. Each month has its own worksheet, and the worksheets are set up
like this:
Column A: Date
Column B: Team Number
Column C: Daily Goal
Column D: Daily Achieved
Column E: Over/Under Goal
And the data looks like this:
8/1/08 1 10 10 0
2 15 10 -5
3 25 30 5
(through team seven)
8/2/08 1 15 15 0
2 12 12 0
3 25 20 -5
(etc.)
I can manually copy, paste, auto fill for each day. Is there some code that
could speed this up? XML? VBA? If not, I can do it by hand.
Thank you!

Visit Debra Dalgleish's site:
http://contextures.com/xlDataEntry02.html
and
http://www.contextures.com/xlVideos01.html#FillBlanks

Author wrote:

Seven teams have their productivity statistics logged daily. The person who
entered the data only entered the date once for the first team, then skipped
seven lines and entered the next date. I am trying to do a pivot chart/table
for each month's data, and the blank lines in the date column are giving me
trouble. Each month has its own worksheet, and the worksheets are set up
like this:
Column A: Date
Column B: Team Number
Column C: Daily Goal
Column D: Daily Achieved
Column E: Over/Under Goal
And the data looks like this:
8/1/08 1 10 10 0
2 15 10 -5
3 25 30 5
(through team seven)
8/2/08 1 15 15 0
2 12 12 0
3 25 20 -5
(etc.)
I can manually copy, paste, auto fill for each day. Is there some code that
could speed this up? XML? VBA? If not, I can do it by hand.
Thank you!

--

Dave Peterson

Concise reply FTW!
Thanks a lot Dave!

"Dave Peterson" wrote:

Visit Debra Dalgleish's site:
http://contextures.com/xlDataEntry02.html
and
http://www.contextures.com/xlVideos01.html#FillBlanks

Author wrote:

Seven teams have their productivity statistics logged daily. The person who
entered the data only entered the date once for the first team, then skipped
seven lines and entered the next date. I am trying to do a pivot chart/table
for each month's data, and the blank lines in the date column are giving me
trouble. Each month has its own worksheet, and the worksheets are set up
like this:
Column A: Date
Column B: Team Number
Column C: Daily Goal
Column D: Daily Achieved
Column E: Over/Under Goal
And the data looks like this:
8/1/08 1 10 10 0
2 15 10 -5
3 25 30 5
(through team seven)
8/2/08 1 15 15 0
2 12 12 0
3 25 20 -5
(etc.)
I can manually copy, paste, auto fill for each day. Is there some code that
could speed this up? XML? VBA? If not, I can do it by hand.
Thank you!

--

Dave Peterson