Hi, I am building anew database for the company i work for. On sheet1 of the database i am having data input and data review. Sheet 2 will be where all the data is kept.

Firstly, i want to inster a user input field with such catagories as "Name" "Product" "Date". with a button next to it to enter the data when clicked. Once clicked, i want the data to be cut from the input field and pasted into the appropriate row in sheet2. I want sheet 2 to be date ordered so that i can pull out data week by week.

So that's the first section. I have seen many macro codes on the net, none of which relate to my query

Secondly, i need a drop down menu on sheet1 which has a tab for each week in the financial year, so 1-52. When you select a week number, i want it to collect the rows of data from sheet2 and which are relevant to the selected week and then to display them on sheet1 for review. Any help anyone could give me would be much appreciated.

If anyone requires any more information regarding my query just ask, im sat at my desk

Best regards,

Dan