Hello,
I am struggling with this one. I need to copy all of the contents on the last row of data from an active workbook to Sheet1Row2 of a pre-defined workbook which has multiple sheets with formulas referencing the data in the cells on Sheet1Row2 of that pre-defined workbook. This code needs to over-write the data that is pre-existing in Sheet1Row2.
So, its copy the contents of the last row of data from sheet1 of a workbook, (names change on that workbook), to sheet1Row2 of a pre-existing workbook,(call this MASTER and the name never changes)
I thought I would be able to figure this out, but am struggling. Any help or guide would be helping and appreciated.
-sXmont
I am struggling with this one. I need to copy all of the contents on the last row of data from an active workbook to Sheet1Row2 of a pre-defined workbook which has multiple sheets with formulas referencing the data in the cells on Sheet1Row2 of that pre-defined workbook. This code needs to over-write the data that is pre-existing in Sheet1Row2.
So, its copy the contents of the last row of data from sheet1 of a workbook, (names change on that workbook), to sheet1Row2 of a pre-existing workbook,(call this MASTER and the name never changes)
I thought I would be able to figure this out, but am struggling. Any help or guide would be helping and appreciated.
-sXmont