Macro to take data from one worksheet to another worksheet in another workbook

Hi Folks,

My plan is to take data from various cells in a worksheet and transfer it to a different workbook and present this data in rows.

I have tried to do this in the following macro

Please Login or Register  to view this content.

To no success.

Please advise what I must correct

Thanks Ihmha,

Your suggestion does work.

I have made some small changes which you will notice.

Please Login or Register  to view this content.

when I use my submit button to run the macro, the file found at C:\Rob\Data.xlsm automatically opens. Is there some code I can include / remove so as to prevent the opening of the file ?

Hi Folks,

I have made some progress. The data is captured from the worksheet successfully but it does not write correctly to the new worksheet, for some reason.

It currently writes the data to "B9" and not what I expected to "B7". Secondly the data is overwriting the old data and not looking for the next open row as I thought it would.

Any advice would be welcomed.

The macro is presented below

Please Login or Register  to view this content.