I receive emails that have an excel attachment, that has a row of data that I copy and paste to another excel spreadsheet. What I need help on is creating a macro that will automate this process so that when I open the excel attachement from my email I can click on the macro from my other spreadsheet and it will pull the row of data that, before was copied and pasted.
The spreadsheet where the data will go is formatted by calender days so the first row has for example 10/01/10, and so on.....