Help a Excel challenged person

[pkstep]

Hi. I am trying to build a drop down menu using excel to save myself a few key strokes. I know how to create the list so long as I put the list (choices for the drop down) on the same worksheet. I have seen other Excel sheets with drop down list that had the data on another spread sheet. For instance when you open a brand new fresh excel spreadsheet you have sheet 1, sheet 2, and sheet 3 along the bottom. The spreadsheet I have seen has the actual work are viewed on sheet 1 and the choices for the drop down menu on sheet 2. Can anyone tell me how to direct the drop down box to pull from another sheet?

Also if I want to create a list of dates starting with 1/1/2006 and then the next one be 7 days later what would I type and drag down to create a list of dates in 7 day increments.

Thanks

 

[lenze]

The secret is to use a Named Range. Name the source range and then in the data validation dialog, enter this name in the source field.

Second Question.

If your first date is in A2. In A3 enter

=A2+7

Drag down as needed

lenze

 

[pkstep]

The secret is to use a Named Range. Name the source range and then in the data validation dialog, enter this name in the source field.

Second Question.

If your first date is in A2. In A3 enter

=A2+7

Drag down as needed

I understand (now) the Named Range theory but still if I name the range Apple, how will I connect sheet 1 with sheet 2? What command or typed statement connect them? Do I just type in Apple on sheet 1 and it will automatically go to the range list on sheet 2?

I saw your response to the date and said "I tried that and instead of 7 days it gave me 7 months ahead." I try it again and your right.

Excel messing with my head

 

[Aadarsh]

Hey pkstep,
When setting up your drop down list in your first worksheet your will have the option of entering the input range. Type Apple (or whatever your named range is) into this field. Select how many lines you want to display at a time and click OK.

 

[lenze]

Actually, you don't need a formula. If you type in the first 2 dates and then select them both, when you data down, Excel will figure out what you want.

lenze