Autopopulate via dropdown

[ollienashchapman]

Hey guys,

I have seen a few other threads on this topic but not quite the same. I have an excel workbook which contains each month on a separate sheet. On each sheet it has each week and the hours I have spent at work per week. I have to fill out a timesheet eachweek and send to my work in order to be paid and i always forget so wanted to try to make it a bit more.... automated?

I have recreated the timesheet as a sheet in the workbook and would like to be able to select the month from the drop down, and then from that select the week, then it will autopopulate the days and hours per what already exists for that week. Now I know how to do the two drop downs so i, however im not sure how i can get it to select a specific sheet to source the data from?

any help would be appreciated.

 

[bruderbell]

This sounds possible. I'd recommend either posting some sample data so that you can get a real response or posting your worksheet somewhere. In the absence of data, I'll just recommend that you take a look at the INDIRECT, MATCH, and INDEX functions in excel. With a combo of them, depending on your data setup, you should be able to get there.

 

[ollienashchapman]

This sounds possible. I'd recommend either posting some sample data so that you can get a real response or posting your worksheet somewhere. In the absence of data, I'll just recommend that you take a look at the INDIRECT, MATCH, and INDEX functions in excel. With a combo of them, depending on your data setup, you should be able to get there.

Hi bruderbell,

Thanks for responding

I have produced a link to my excel doc. On the timesheet sheet I have the two drop downs, month and week, depending on which month you select it lets you select the weeks that start with these dates. If you look on the month sheets you can see all the weeks are there. The sheet that the drop downs are getting the data validation from is hidden. theres also a quick print macro button on the timesheet sheet.

Thanks again

Filename: "Timesheet for Mr Excel.xlsm" (66.60 KB)
Location: http://filelink.nam.nsroot.net/FileLink/GetFile.aspx?id=DE79F8EC-6A14-49E2-92E4-A83A3193B65F
(Note: This file will not be available for download after 05 Jun 2014)