hey all,
i have a excel sales summary report that comes out every week. i was
wondering if there was a way to extract the Current Order Amount column from
the report and place it in a new excel worksheet in say column A.

Then when the next report comes out take that same column in put it column B
to see a comparison of the Current Order Amounts?

And is there a way to do this automagically?

thanks,
rodchar