automatic data fill , based on list into dynamic range

[dave h]

Hi

I'm tring to build a dynamic spreadsheet for forecast modelling over
differering future periods where the end user chooses the periods to be
used...

ok this is what i am trying to do......its about defeated me.after 5 hours
of trying -maybe i need to go on a advanced course or vba....

i have a list of periods that are in a single column list on Sheet1 and run
from p1-2004 to p13-2034 (yep 30 yrs!)

Sheet2 - has two list boxes:

1st list box - is where end user chooses 'start period' eg 'p11-2004' (
filled in using the data validation option from the excel menu that uses the
column list range in sheet1)
2nd list box - is where end user chooses 'end period' eg p13-2005 (same
validation as above)


now what i am after.....

What i want on sheet3 is the 1st column of a dynamic range to be populated
based on the start and end periods selected on the above combo boxes,using
the data held in sheet1

I've got the dynamic range set up fine in sheet 3, just cannot populate it
with the data based on criteria in list boxes 1 and 2 held in sheet1


Finally I want a calculation for each period dropped into col 4 of sheet3
to sum user input that will be input into col 2 and col 3 of sheet3- cant
figure how to do this either!

anybody help on this??

regards

dave

 

[arno]

Hi Dave,

I've got the dynamic range set up fine

Well, where's the problem then

Write the starting date in the first cell (here A1). Fill the range to
the end with the following formula (or calculate the date with VBA):

=date(year(a1);month(a1)+1;1)

format the cells with the date with format MM-YYYY (do not display
days).

Regards

arno