Copy and Paster an autosum to new workbook

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?

This macro will search in Column J for the first "SUM", copy it, insert a new spreadsheet into your workbook and paste that value into cell A1.

Please Login or Register  to view this content.

ChemistB

I need to read more. Thanks VBA!
I just bought the Definitive Guide to Excel VBA by Kofler.

ChemistB

Hi,

Thanks for getting back to me, I have been away so I have only just had the chance to get back to this.

If I was to combine the two codes would this be correct:

Please Login or Register  to view this content.

Rather than add a sheet can I specify a spreadsheet to open and then get it to paste into that?

e.g Idealy I would like it to go to C:\Dashboard.xls and then in the sheet called Data and Cell F20

also, When I ran the above code it created two sheets and pasted the data in rather than just the one sheet.