Hi,

Not sure if this can be done or not.

Is there any way a macro can search the current work sheet for an autosum in Colum J, copy the value and then open a new spreadsheet and paste the value in to a predetermined cell?