creating a list box

[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

[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)

"WylieDude" <redmanz55@hotmail.com> wrote in message
news:#hixROWYGHA.3684@TK2MSFTNGP05.phx.gbl...
> 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
>
>