creating a list box

W

WylieDude

I am creating a budget spreadsheet. I am trying to create a list box where I
choose what month I want to start with and the other months follow in each
column, depending on what month picked...

Thanks in advance
 
B

Bob Phillips

Put your 1st day of your starts month in a cell, say A1 as 01/04/2006, and
in the next cell add

=DATE(YEAR(A1),MONTH(A1)+1,1)

copy across to the 12th cell. Then format all 12 cells as mmm. Change the
start cell date, and all the rest will ripple along.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top