Code for pasting as per criteria

[Veeru]

Hi,

We have discussed this scenario earlier, but I have marked that post as solved hence again raising it as we have more criteria’s.

Attaching sample sheet and code. Everything is same except we are adding 3 more columns .

Some tabs have all these columns where as some has only one or two.

In NCF Data tab , whenever we add “Fund Number”, ”Fund Name”, ”Product Category”, it should add in that particular source group as mentioned in Col. A.

In rest of tabs we can simply add in last row

Thanks