So here's my problem.
I have a spreadsheet with rows of data that have a start and end date and monthly amounts to charge for the months in that range.
So my data looks like this:
Customer Contract# Bill Start Date Bill End Date # of Payments Monthly Amt to Bill
PepsiCo 10001 7/1/2012 6/1/2012 12 $1,000
I'm trying to get to this:
Customer Contract# Bill Start Date Bill End Date Monthly Amt to Bill
PepsiCo 10001 7/1/2012 7/31/2012 $1,000
PepsiCo 10001 8/1/2012 8/31/2012 $1,000
PepsiCo 10001 9/1/2012 9/30/2012 $1,000
PepsiCo 10001 10/1/2012 10/31/2012 $1,000
I know this can be accomplished in VBA w/ loops and manipulating ranges but I need some direction.
Can anybody help?
Thanks!
-Gogie
Bookmarks