View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
u473 u473 is offline
external usenet poster
 
Posts: 184
Default Generate calendar column month headers in YYMM Format

Thank you very much. Your answer was very much appreciated.
Assuming that I push that calendar 2 columns to the right and have a
column
of unique dates in A, and Values in B column, like :
A B
11/15/2008 15,000
12/25/2008 8,000
02/05/2009 12,000
How do I distribute these values in their respective columns ?
I know I have to loop thru the range in column A, but how do I refer
to the appropriate column ?
Thank you again and have Happy Holidays !
J.P.