Re: $$Excel-Macros$$ How to use a drop down list to select data from another sheet

2010-12-31 Thread P.VIJAYKUMAR
Dear Steve, If you want to get a drop down list for data that is in Other sheet, First set the cursor or ur position where u want the list to appear then go to the sheet which you have the data then select all the Data and give a name to the range of cells you have selected or in other words cre

$$Excel-Macros$$ How to use a drop down list to select data from another sheet

2010-12-30 Thread Steve
Each month I must compare monthly expenses to the budget (forecast). To do this I have created a spreadsheet with a drop down list where the user selects the appropriate month to analyze. I would then like the data to be pulled in from another tab using the appropriate column based on the month sel