Results 1 to 3 of 3

Thread: Help with rearranging similar entries side by side from two separate workbooks in one worksheet
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Apr 2012
    Location
    Houston, TX
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Help with rearranging similar entries side by side from two separate workbooks in one worksheet

    Hello All,


    I am currently working on a project wherein I am suppposed to compare the entries made by my supervisor and the entries that are generated from the software. This is becoming very tedious as I have to keep the two spreadsheets open side by side, then search for similar entries by eye balling and copy and paste them together side by side to show comparison.

    I would be very grateful if someone may help me with a macro that can search for keywords, reorder and rearrange the entries. I am attaching the three worksheets for a better picture.

    Worksheet A is the one prepared by my supervisor.
    Worksheet B is the one generated from the Software
    Worksheet C is what the macro code should be doing (desired). Right now worksheet C has been done manually by me which took me 3 hrs


    Thanks a lot in advance.

  2. #2
    New Member
    Join Date
    Apr 2012
    Location
    Houston, TX
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help with rearranging similar entries side by side from two separate workbooks in one worksheet

    I am unable to attach the worksheets. Can anyone guide me how to attach excel files here on this thread?

  3. #3
    New Member
    Join Date
    Apr 2012
    Location
    Houston, TX
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help with rearranging similar entries side by side from two separate workbooks in one worksheet

    You may download the worksheets from the links below for review
    Worksheet A - FileSwap.com : Worksheet C.xlsx download free
    worksheet B - FileSwap.com : Worksheet B.xls download free
    Worksheet C - FileSwap.com : Worksheet A.xlsx download free

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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