Open a file from browse window and perform VLOOKUP

Hi all,

I am very inexperienced with VBA, I usually manage to just use macros to achieve most of what I need.

If anyone in this group is able to help I would be most grateful.

Presently I have a weekly report that contains about 30 columns and about 3000 rows of data, I need to be able to validate one weeks data against the previous weeks data and then perform a couple of actions. I will try to break it down;

1. Receive and save this weeks data file (I have attached a file called 'this weeks data' and 'last weeks data' just for example
2. Run macro
   
   1. Open a windows browser window
   2. Select location of 'last weeks data' file - this file will be password protected, so may need to allow for password to be entered
   3. use VLOOKUP function to find 'ID' in 'this weeks data' that was included in 'last weeks data'
      
      1. For rows that exist in last weeks data, remove from this weeks data, create new worksheet 'already submitted' and paste the rows
      2. Remove any blank rows from 'this weeks data' left after VLOOKUP
   
   
3. Save 'this weeks data' as 'Filename_Amended_Date"
4. End

If I have not explained this very well please let me know, I am hoping that this is relatively easy to do and if I see the VBA for this I am confident I can work out how to edit/amend if I need to

Thanks in advance for any help on this :help


Attachment 15268Attachment 15269