Combine data of multiple sheets to one with a code - add one condition

[RAJESH SHAH]

Hello experts
This code is shared by beyond excel earlier. I need to add one additional condition in this code to update this and need your expertise to do so. IF Column A = Export, Column D = Export then in column S = Export. IF Column A = Export, Column D = URP then in column S = B2C
as shown in the Expected result sheet.
Thank you in advance.

[Marc L]

Hello,

which code ?

According to your explanation why not just using a filter or an advanced filter ?

[RAJESH SHAH]

All my sheets are inter connected and making changes in the middle will effect all the other sheets. I just want to add a code in the end to replace B2C with Export and the result will be corrected in the connected sheets. I tried to write the code but I am getting a compile error.

Please Login or Register  to view this content.

[Marc L]

As the formula contains two IF( but at the end 3 ")))" so try to remove one …

[RAJESH SHAH]

I removed and tested again but still compile error...Invalid or unqualified reference at this line .Columns

[RAJESH SHAH]

I think I was able to edit one of the earlier codes and get this one right. Maybe it will work on the original data too. 爛爛

Please Login or Register  to view this content.

[Marc L]

Just combining the Range once :

Please Login or Register  to view this content.

[RAJESH SHAH]

Eeek. I missed something again. Again not the expected answer. Sorry Marc L. I will re check the problem and will be back soon.

[RAJESH SHAH]

The IF condition has to include OR / AND in the formula. I forgot to add a few lines in the sample data where D = URP and A <> Export. I have added them in this file. So, sorry for the blunder.

[RAJESH SHAH]

The issue is resolved now. The problem was in the source sheet which is corrected now. Thank you Marc for your support.