automatic data fill , based on criteria 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 sheet2


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

 

[Mandy]

If you have not received help yet. Go to the following
website and post it there. In this website you can
attach an example of the file.

http://www.excelforum.com/forumdisplay.php?
s=f0059e87079673c3466a8461e1e405d1&daysprune=&forumid=5

I think I can help with some v-lookups and Pivot tables.
I'm not sure why you are using a list box, I think that
is part of the problem.

 

[dave h]

hi

im using a list box because i want to control what a user chooses -sorry an
obvious and unhelpfull reply - but i'cant explain it any better!