Good Morning,

I need to produce a spreadsheet on a weekly basis that is derived from two
spreadsheets.

Currently I link two spreadsheets into Access and then run a query to
produce a single spreadsheet containing the combined data. The problem is
this is not real quick and requires tweaking the formats of the two
spreadsheets.

I am trying to see if I can do this in excel via a macro and/or formulas.

Is this possible or should I stick with access?

Thanks

Fred