Opening second Excel workbook and copying contents of worksheet back to first workbook
Posted on 2016-11-21
I always forget how to do this.
I have a project workbook, "wb1.xlsm" and 3 source workbooks, s1.xls, s2.xls and s3.xls.
In wb1.xlm there are 3 destination worksheets names "d1", "d2", & "d3". In workbooks s1, s2 and s3 there is only one sheet in each.
I want to open each of the source workbooks in order.
Read the contents of cell "G1" and determine based on the value in the cell if the whole sheet needs to be pasted back in "wb1.xlsm" to sheet "d1", "d2" or "d3"
Can someone help me with this?