Hi All,
I've been trying for a few days to find and/or manipulate a macro which can perform the following.
It has to Import 2 cells from the same row but different columns from a external Spreadsheet, the quantity of rows from the external spreadsheet can vary from 5 to 500+ rows thus the macro should be able to a) determining the external docs row count and b) insert those rows into the master sheet between a determined set of rows.
so for example.
External.xls
Row 23 -> 43 and Columns H and K contains the information required.
Master.xls
20 Rows need to be inserted into Sheet1, Row 50 and Columns A and B need to be populated with the content from H and K from the External.xls document
Hope that makes sense.
The macro I worked on could insert a row but the information inserted would span all cells in all Columns rather than inserting the information into 1 cell - unfortunately the macro I did have was over written and I didn't save a copy! doh - but ill try to find the original I was working on after posting this.
Thanks for taking the time to read this.
I've been trying for a few days to find and/or manipulate a macro which can perform the following.
It has to Import 2 cells from the same row but different columns from a external Spreadsheet, the quantity of rows from the external spreadsheet can vary from 5 to 500+ rows thus the macro should be able to a) determining the external docs row count and b) insert those rows into the master sheet between a determined set of rows.
so for example.
External.xls
Row 23 -> 43 and Columns H and K contains the information required.
Master.xls
20 Rows need to be inserted into Sheet1, Row 50 and Columns A and B need to be populated with the content from H and K from the External.xls document
Hope that makes sense.
The macro I worked on could insert a row but the information inserted would span all cells in all Columns rather than inserting the information into 1 cell - unfortunately the macro I did have was over written and I didn't save a copy! doh - but ill try to find the original I was working on after posting this.
Thanks for taking the time to read this.