Compare 2 columns if it matches all columns must go toSheet2

Closed
Reinette - Jul 7, 2022 at 01:04 PM
abdelfatah_0230 Posts 73 Registration date Thursday July 18, 2019 Status Member Last seen July 23, 2022 - Jul 23, 2022 at 05:24 AM

Hello,

Thank you for putting the time aside to help me.

There are 2 sheets, Summary and Journal.

Step 1: In the Summary sheet, I added Column E to check if there is a match between Column D and F. If there is a match, the records should be shown on the Journal sheet. 
Step 2:  In the Summary sheet, there is a 1 in Column B and a 9 in Column C the data should go to the Journal sheet.

Your help is much appreciated.

Windows / Edge 103.0.1264.44

Related:

1 response

abdelfatah_0230 Posts 73 Registration date Thursday July 18, 2019 Status Member Last seen July 23, 2022
Jul 23, 2022 at 05:24 AM

Hi ,

should  issue  some  the  pictures  before  and  after   until others members  can  help  you .

best  regards,

abdelfattah

0