Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic data fill , based on list into dynamic range
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic data fill , based on list into dynamic range
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic range based on another column | Setting up and Configuration of Excel | |||
Data Validation List from a Dynamic Named Range on Another Workshe | Excel Worksheet Functions | |||
Data Validation via Dependent List defined by Dynamic Range | Excel Discussion (Misc queries) | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
dynamic summed range based on a variable | Excel Worksheet Functions |