Macro Input Button for Data Sorting

Hi,

I have a sheet with Information like Date(G), Currency(H), Status(I) and other A,B,C,D,E,F Columns.

I am trying to code a Button which will take input about Date and Currency and set the third parameter constant that is status to "Executed". For this input data then It will fetch the columns A,C,E and put them in a new spreadsheet.

Date in format: 27-Jan-2016 and Currency like: USD.

Please assist.

Thanks in advance.

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 use the paperclip icon to open the upload window.

View Pic

Control + q to run the macro in the attached file.

Please Login or Register  to view this content.

..........