RhysPhelps
New Member
- Joined
- Mar 19, 2009
- Messages
- 20
Bonjour everyone. Thanks to Yard's extermely useful help i am nearly the envy of the office but i now have another problem.
I have a spreadsheet of contracts that are about to expire and am creating a pivot table from it so that i can add the details to a calendar template (Don't ask :P). however a contract doesn't expire on everyday of the year so i need a macro that can create rows and insert the next date.
For example.
The end date is contained in column F so at the moment i have
F
1 End Date
2 01/01/2009
3 04/01/2009
4 05/01/2009
5 07/01/2009
and so on
What i would like the macro to do is insert 2 rows between F2 and F3 and fill in the missing dates. There are other columns with data but they can be filled in using cut and paste
The Sheet is called contracts and the End date column goes to F250 (although the sheet may change month by month so if it is possible to just perform the action on F2 onwards that would be brilliant)
I'm a complete newbie on VB and macros but i have been having a read so if anyone has some recommended texts or websites then hit me up
Ta all
I have a spreadsheet of contracts that are about to expire and am creating a pivot table from it so that i can add the details to a calendar template (Don't ask :P). however a contract doesn't expire on everyday of the year so i need a macro that can create rows and insert the next date.
For example.
The end date is contained in column F so at the moment i have
F
1 End Date
2 01/01/2009
3 04/01/2009
4 05/01/2009
5 07/01/2009
and so on
What i would like the macro to do is insert 2 rows between F2 and F3 and fill in the missing dates. There are other columns with data but they can be filled in using cut and paste
The Sheet is called contracts and the End date column goes to F250 (although the sheet may change month by month so if it is possible to just perform the action on F2 onwards that would be brilliant)
I'm a complete newbie on VB and macros but i have been having a read so if anyone has some recommended texts or websites then hit me up
Ta all