Results 1 to 4 of 4

Thread: Move rows based on cells!

  1. #1
    Seeker Daghs's Avatar
    Join Date
    Apr 2021
    Posts
    13
    Articles
    0
    Excel Version
    Excel10

    Move rows based on cells!



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

    Hi,


    for giving an example here I'm using few rows but actual data
    contains hundreds of rows.


    I have three sheets called DAILY,RECORD & MERGE.
    DAILY & RECORD sheets have eight columns each.
    DAILY sheet has details of daily wages,allowances,overtime etc
    while RECORD sheet has accumulated values of the same.

    what I want is a move (not copy) of two sheets ("DAILY" & "RECORD") based on serial's (in column "A") in one sheet ("MERGE").

    like in "DAILY" sheet in column "A" there's a serial ID "AL"
    now if in "RECORD" sheet there's also serial ID "AL"

    Row from "DAILY" sheet will be moved to "MERGE" sheet (from column "A" to "H") &
    Also Row from "RECORD" sheet will be moved to "MERGE" sheet (from column "J" to "Q")
    But in same Row of "MERGE" sheet (and so on).

    so only serials which are not identical in "DAILY" & "RECORD" sheet would be left & identicals would be in "MERGE" sheet.

    I've also attached file for details!

    if anybody could suggest any "MACRO" or "POWER QUERY" way it'd really helpful.

    Thanks!
    Attached Files Attached Files

  2. #2
    Seeker Daghs's Avatar
    Join Date
    Apr 2021
    Posts
    13
    Articles
    0
    Excel Version
    Excel10
    Guys no suggestions!
    I mean, I could use any help🙄

  3. #3
    Seeker Daghs's Avatar
    Join Date
    Apr 2021
    Posts
    13
    Articles
    0
    Excel Version
    Excel10
    I have no clue if what I'm asking is even possible or not coz my skills are at the beginning level
    but if it is not possible I could re-ask my question in different way! 😕

  4. #4
    Acolyte caabyyc's Avatar
    Join Date
    Dec 2014
    Location
    Burnaby/Calgary
    Posts
    41
    Articles
    0
    Excel Version
    2016

    Talking

    In worksheet "MERGE"

    A1=IFERROR(INDEX(DAILY!A:A,SMALL(IFERROR(ROW(DAILY!$A$1:$A$5000)*1^MATCH(DAILY!$A$1:$A$5000,RECORD!$A:$A,),9^9),ROW(A1))),"")

    Press control ,Shift and Enter (3 keys) to run (if you press them successfuly, you will see "{" and "}"
    Then copy to right and down



    J1=IF($A1="","",VLOOKUP($A1,RECORD!$A:$H,COLUMN(A1),))

    then copy to right and down

Posting Permissions

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