Ok, I have a file that gets sent to me in an email... the example file attached is examplefile1... I also have the main file that I work with being examplefile2 that is attached... What I need is a macro that I can run in examplefile2 that allows me to select the examplefile1 open it as a temp file or whatever is needed to copy the order number column and paste it into the main exapmlefile2 location...

To try to explain again, examplefile1 is emailed to me, I open examplefile2 and run a macro in which it allows me to select the emailed file that I have saved somewhere and pulls the order numbers from it and pastes them into examplefile2 in the proper area.

PLEASE NOTE THESE EXAMPLE FILES ARE EXTREMELY SIMPLE COMPARED TO WHAT I AM WORKING WITH... I JUST NEED THE SIMPLE IDEA OF HOW TO DO IT AND I CAN GET IT TRANSLATED TO MY ACTUAL WORKSHEETS...


Thanks,examplefile1.xlsxexamplefile2.xlsx

TIA!!!