Forum

VBA Code to Compare...
 
Notifications
Clear all

VBA Code to Compare two workbooks with conditions

2 Posts
2 Users
0 Reactions
130 Views
(@marta1)
Posts: 1
New Member
Topic starter
 

Hello,

Hope you are all doing great,

I am looking for a help on this topic,

So I have two files, the source file and the target file, I would like to compare the source file with some conditions against the target file, if there are missing rows in the target file then those missing rows should be added to the another sheet of source file.

Could you please me with creating macros?

Thanks for your help in advance

 
Posted : 15/01/2023 4:11 am
(@catalinb)
Posts: 1937
Member Admin
 

Hi Marta,
Any reason for a VBA solution only?
It's much easier to do that in Power Query, see attached solution that returns the RowsOnlyInSource matching the criteria.

 
Posted : 18/01/2023 8:16 am
Share: