Hi,
If you enjoy a challange, you'll love this one !
I am trying to import data from another workbook, without much success I may add !
Below is an example of what I am trying to achieve.
Book1 is named 'Analysis', I want to import the data from column 5 in workbook 2 named 'reports'.
Example of Book 2 'reports'
the result should be that the data of column E of book 2, would be imported into column B of book 1, when I type in column A the job number on book 1.
The 'reports' are emailed to me on a regular basis, and will require updating, you will notice that the cell formats are different, unfortunately I have no control over this, does that matter ? because everything I have tried just hasn't worked. I kid you not, I have been at this for day's, reading all the threads on this forum, and trying various solutions to other peoples problems. But none of them seem to work for me.
thanks.
TURK.
If you enjoy a challange, you'll love this one !
I am trying to import data from another workbook, without much success I may add !
Below is an example of what I am trying to achieve.
Book1 is named 'Analysis', I want to import the data from column 5 in workbook 2 named 'reports'.
Book1.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Jobno | Status | CNXcode | Date | ||
2 | 11112222 | 02/01/2009 | ||||
3 | 22223333 | 02/01/2009 | ||||
4 | 44444444 | 02/01/2009 | ||||
5 | 12345678 | 02/01/2009 | ||||
6 | ||||||
7 | ||||||
8 | ||||||
analysis |
Example of Book 2 'reports'
the result should be that the data of column E of book 2, would be imported into column B of book 1, when I type in column A the job number on book 1.
Book2.xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | jobno | customer | region | data | status | date | ||
2 | 22221111 | allen | south | COM | 02/01/2009 | |||
3 | 77770000 | smith | south | COM | 02/01/2009 | |||
4 | 11112222 | jones | south | PAS | 02/01/2009 | |||
5 | 12345678 | kenny | south | COM | 02/01/2009 | |||
6 | 44444444 | audran | south | PAS | 02/01/2009 | |||
7 | 11112222 | hutch | south | PAS | 02/01/2009 | |||
8 | ||||||||
9 | ||||||||
reports |
The 'reports' are emailed to me on a regular basis, and will require updating, you will notice that the cell formats are different, unfortunately I have no control over this, does that matter ? because everything I have tried just hasn't worked. I kid you not, I have been at this for day's, reading all the threads on this forum, and trying various solutions to other peoples problems. But none of them seem to work for me.
thanks.
TURK.