Hey all,
First off, I would appreciate it if I could be directed to the right forum and place to ask my question:
I would like to combine two data from two worksheets. Because I have so much data I need excel to:
1)find the text that matches from column A of both worksheets (1 & 2)
2)import columns B through E from the corresponding matched text from worksheet 2 into columns F through I in worksheet 1.
In the attachment the goal of this representative sample is to place from worksheet 2
76076 19900216 1984 .
into columns F through I in worksheet 1, so that the completed column looks like this
Cisco Systems 19900216 3577 No 18.000 76076 19900216 1984 .
Thanks way in advance for you help and I will try my best to follow instructions as they are politely presented,
Zach
First off, I would appreciate it if I could be directed to the right forum and place to ask my question:
I would like to combine two data from two worksheets. Because I have so much data I need excel to:
1)find the text that matches from column A of both worksheets (1 & 2)
2)import columns B through E from the corresponding matched text from worksheet 2 into columns F through I in worksheet 1.
In the attachment the goal of this representative sample is to place from worksheet 2
76076 19900216 1984 .
into columns F through I in worksheet 1, so that the completed column looks like this
Cisco Systems 19900216 3577 No 18.000 76076 19900216 1984 .
Thanks way in advance for you help and I will try my best to follow instructions as they are politely presented,
Zach