PDA

View Full Version : Import value from adjacent cell in another workbook if cell meets criteria



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

mancubus
01-02-2016, 06:58 AM
post your workbooks and give us an example of manually done copy/paste.

sharky12345
01-02-2016, 07:04 AM
Thanks - will do, but there will be a slight delay because I'll have to sanitise the workbook.