ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   need help with a formula in excel 2003 (https://www.excelbanter.com/excel-worksheet-functions/182920-need-help-formula-excel-2003-a.html)

tboyer

need help with a formula in excel 2003
 
I am creating a project tracking workbook in Excel 2003 for my work. I have
created a worksheet with project info including a project end date. I have
created a drop down list for all the months in the year so we can track these
projects. I am wanting to create a formula or somehow link those dates to
individual worksheets for each month.

For example, when the month of July is selected in a project it will
automatically send the info on that job to a seperate worksheet titled July.
I need a formula that knows which worksheet to send the project to based on
the date selected from the drop down list of months. I have created a
worksheet for every month in the same workbook as my Job Tracking worksheet.

Please send me help at



All times are GMT +1. The time now is 05:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com