Hey All,

I receive a weekly statisical report (in excel) from which data must be added to an existing monthly report (in excel). After researching and writing a simple macro, I realized I had no idea what I was doing and needed dire help. This is what I need the macro to do.

1) Prompt the user to choose which file from which to extract data.
(perhaps a "Application.GetOpenFilename"?)

2) Extract certain cell specific data from a specific worksheet on spreadsheet #2, and add it to existing cell/worksheet specific data in spreadsheet #1.

3) Be able to reformat and reuse this macro for other uses. (Once I see how the macro works, I should be able to figure this out)

Any help would be greatly appreciated. Thanks