white_flag
01-19-2012, 05:32 AM
Hello I have an sheet with data (as an master sheet) from this one I copy to another file some data (as slave)
ThisWorkbook.Sheets("data").Copy After:=wb.Sheets("Sheet1")
in the master sheet I have some name data will defined some ranges as reference. with the above code the data will be copied with reference to master. Can be copied as reference to herself to to master (because the data will be inside of the slave).
='[MasterWorkbook.xls]Data'!$C$644:$M$667 to be
=Data'!$C$644:$M$667
ThisWorkbook.Sheets("data").Copy After:=wb.Sheets("Sheet1")
in the master sheet I have some name data will defined some ranges as reference. with the above code the data will be copied with reference to master. Can be copied as reference to herself to to master (because the data will be inside of the slave).
='[MasterWorkbook.xls]Data'!$C$644:$M$667 to be
=Data'!$C$644:$M$667