Need to merge data from two worksheets automatically very tricky

zachzach

New member
Joined
Jan 12, 2013
Messages
2
Reaction score
0
Points
0
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​
 

Attachments

  • merged sheets TO BE SENT OUT.xlsx
    10.4 KB · Views: 20

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
If you have a similar need Mary, post separately and we can address you specific need.
 
Top