Copy values from one file to another file but copy when date and name match

There is two file attached one name is karanja and second file name is plusminus look in to the file karanja in cell O49 i apply yellow color so you can easily understand so in cell O49 date is 02/01/21 then in file plusminus
firstly find name karanja which is in N column then in N column find date 02/01/21 then look in to file karanja there is cell W51 in that cell number is 17 that is positive number so copy that number in file plusminus where is name karanja which is in N column where is date 02/01/21 but paste that number in the column which had heading is Minus that is column P then we go to next date in file karanja we can see date 04/01/21 be remember we always took date from bottom in every data block that is the reason i apply yellow colour to that specific date so now we reach to date 04/01/21 which is in cell O81 and see the value of cell W83 which is negative number
so put that 68 number in file plusminus where is date 04/01/21 but paste that number in column which had heading name plus because it is negative number so we paste that number in plus column it means O column then also copy number 2341 which is in cell N81 in file karanja then paste that number in file plusminus in column M near that date then go to next date and so on etcetera so please give me VBA code for above process

With both files in same folder and extra data in Column O

Please Login or Register  to view this content.

Kind regards
Leo

can you also copy values of N column from karanja file for example in karanja file in cell N49 value is 2296 copy that value in file plusminus near date 02/01/21 in column M of plusminus file and so on etcetra ,
please check attachment file

Try

Please Login or Register  to view this content.

Kind regards
Leo

What if both values are positive ?
What if both values are negative ?
What if there are more than 2 dates ?
and last witch MRN No to sheet plusminus ?

and maybe you dont know but negative number can never be greater than positive number

if both values are positive then do sum of both values and paste that values in plusminus sheet where is column heading minus if both values is negative then do sum of that values and paste sum result in plusminus sheet where is column heading plus, it is not possible that more than 2 same dates, and about MRN NO take only one MRN No which is came first , and i know negative number can never be greater than positive but for example -194 this negative number in one cell and 36 number in another cell first convert this -194 in to positive number like 194 then minus 36 from 194 like this 194-36=158 then paste this 158 number in plusminus sheet where is heading plus

Please Login or Register  to view this content.

Kind regards
Leo