Save button and a drop down to specify where to copy the data.

[af25]

Hello,

I have a drop down containing all the weeks of a year. When I select the week and enter my appropriate data on one sheet I then want to be able to reference this when a button is pressed in order to copy the data over to a specific line on a table on another sheet.
The second sheet is to be used to store a table of data with each week going down vertically.

So for example I click on 01/01/18 on the drop down, enter my relevant data in the cells I've set up, and then when I press my button that data is transferred over to the second sheet and on the appropriate line of 01/01/18.


Thank you in advance.

[dflak]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.