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