Hey All,

I receive a weekly statisical report (in excel) from which data must b
added to an existing monthly report (in excel). After researching an
writing a simple macro, I realized I had no idea what I was doing an
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 o
spreadsheet #2, and add it to existing cell/worksheet specific data i
spreadsheet #1.

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

Any help would be greatly appreciated. Thank

--
tempac
-----------------------------------------------------------------------
tempacc's Profile: http://www.excelforum.com/member.php...fo&userid=2440
View this thread: http://www.excelforum.com/showthread.php?threadid=38008