Hey Guys,
I would like to write in column AL the start date and in column AM the end date of the events in column B.
Example:
Allured starts 11/12/05 and ends on 11/10/05
American Geophicist starts 12/01/05 and ends on 12/10/05
American Academy starts 2/26/06 and ends on 2/28/06
How would do this using VBA.
THanks
I would like to write in column AL the start date and in column AM the end date of the events in column B.
Example:
Allured starts 11/12/05 and ends on 11/10/05
American Geophicist starts 12/01/05 and ends on 12/10/05
American Academy starts 2/26/06 and ends on 2/28/06
How would do this using VBA.
THanks
Daily for MAR update.XLS | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |||
1 | ; | ;November;2005 | 11/01/05 | 11/02/05 | 11/03/05 | 11/04/05 | 11/05/05 | 11/06/05 | 11/07/05 | 11/08/05 | 11/09/05 | 11/10/05 | 11/11/05 | 11/26/05 | 11/27/05 | 11/28/05 | 11/29/05 | 11/30/05 | ; | ||
2 | D | Allured;Publishing;Corporation;-;2005;Face;&Body;Spa;&Healthy;Aging;Conference;&Exhibition;[Moscone;Approved;Definite;-;Moscone;W] | 0 | 100 | 100 | 300 | 300 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ; | ||
3 | ; | ;December;2005 | 12/01/05 | 12/02/05 | 12/03/05 | 12/04/05 | 12/05/05 | 12/06/05 | 12/07/05 | 12/08/05 | 12/09/05 | 12/10/05 | 12/11/05 | 12/26/05 | 12/27/05 | 12/28/05 | 12/29/05 | 12/30/05 | 12/31/05 | ||
4 | D | American;Geophysical;Union;-;Fall;Meeting;[Moscone;Approved;Definite;-;Moscone;W] | 117 | 663 | 3,237 | 3,783 | 3,900 | 3,900 | 3,237 | 1,443 | 273 | 117 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
5 | D | The;American;Society;for;Cell;Biology;-;Annual;[Moscone;Approved;Definite;-;Moscone;S] | 0 | 0 | 0 | 0 | 0 | 0 | 60 | 150 | 1,140 | 2,820 | 3,000 | 0 | 0 | 0 | 0 | 0 | 0 | ||
6 | ; | ;January;2006 | 01/01/06 | 01/02/06 | 01/03/06 | 01/04/06 | 01/05/06 | 01/06/06 | 01/07/06 | 01/08/06 | 01/09/06 | 01/10/06 | 01/11/06 | 01/26/06 | 01/27/06 | 01/28/06 | 01/29/06 | 01/30/06 | 01/31/06 | ||
7 | D | IDG;World;Expo;(Macworld);-;Macworld;Conference;&Expo;[Moscone;Approved;Definite;-;Moscone;N;&S] | 0 | 0 | 0 | 0 | 68 | 128 | 400 | 868 | 3,220 | 3,932 | 4,000 | 0 | 0 | 0 | 0 | 0 | 0 | ||
8 | D | Society;of;Critical;Care;Medicine;-;Annual;Congress;[Moscone;Approved;Definite;-;Moscone;W] | 0 | 0 | 0 | 19 | 494 | 1,197 | 1,881 | 1,900 | 1,824 | 1,330 | 342 | 0 | 0 | 0 | 0 | 0 | 0 | ||
9 | ; | ;February;2006 | 02/01/06 | 02/02/06 | 02/03/06 | 02/04/06 | 02/05/06 | 02/06/06 | 02/07/06 | 02/08/06 | 02/09/06 | 02/10/06 | 02/11/06 | 02/26/06 | 02/27/06 | 02/28/06 | ; | ; | ; | ||
10 | D | American;Academy;of;Dermatology;-;Annual;National;Meeting;[Definite;-;Moscone;N;&S] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 65 | 130 | ; | ; | ; | ||
11 | T | Anheuser-Busch;Companies;-;2006;Anheuser-Busch;Regional;Sales;Meeting;[Tentative;-;Moscone;S] | 8,000 | 8,000 | 8,000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ; | ; | ; | ||
12 | D | Annual;Dialysis;Conference;-;2006;Annual;Dialysis;Conference;[Moscone;Approved;Definite;-;Moscone;W] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2,250 | 2,160 | 877 | ; | ; | ; | ||
Moscone |