sharky12345
01-02-2016, 01:48 AM
I have a range of values in H2:H22 on a closed workbook and I want to import those values into my existing workbook only if the adjacent cell value in column G is "YES".
For example, the cell where I need the data imported to is cell AB2, I need the code to look through H2:H22 on Sheet1 of the source workbook and if "YES" is found import the value from the same row in column G. If more than one value is found then I need each value to be inserted with a forward slash between each value like this;
VALUE 1 / VALUE 2 / VALUE 3
so that AB2 would contain the above.
Posted elsewhere too but with no replies:
http://www.mrexcel.com/forum/excel-questions/908438-import-value-adjacent-cell-another-workbook-if-cell-meets-criteria.html
For example, the cell where I need the data imported to is cell AB2, I need the code to look through H2:H22 on Sheet1 of the source workbook and if "YES" is found import the value from the same row in column G. If more than one value is found then I need each value to be inserted with a forward slash between each value like this;
VALUE 1 / VALUE 2 / VALUE 3
so that AB2 would contain the above.
Posted elsewhere too but with no replies:
http://www.mrexcel.com/forum/excel-questions/908438-import-value-adjacent-cell-another-workbook-if-cell-meets-criteria.html