Daghs
New member
- Joined
- Apr 22, 2021
- Messages
- 13
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel10
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!
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!