Results 1 to 5 of 5

Thread: Need to merge data from two worksheets automatically very tricky

  1. #1

    Need to merge data from two worksheets automatically very tricky



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    Attached Files Attached Files

  2. #2

  3. #3
    Quote Originally Posted by zachzach View Post
    Solved
    How did you solve it, using VBA?

  4. #4
    If you have a similar need Mary, post separately and we can address you specific need.

  5. #5
    Quote Originally Posted by Bob Phillips View Post
    If you have a similar need Mary, post separately and we can address you specific need.
    Sorry, will do! Was curious, that's all.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •