Partial match : Write to new sheets

Question

Hello,

Based on below key word I need to create new sheets based on sheet name(Attached file)

1. Row no 7 condition should filter (Access and Point) and write records to sheet name(Wireless AP)

2. Row no. 7 condition should be AP(Should be equal) and Capacity(not equal to) and write to sheet name(Wireless AP)

3, Row no 1 to 6 - Key word should search in Sheet1 and write it to respective sheet name mentioned in Column B

Regards,

Chandrashekar B

Book1.xlsx

Chandrashekarb · Answer

Hello,

Thanks for the suggestion. I will try to get the solution.

Regards,

Chandrashekar B

alexnajm · Answer

It’s probably easiest to put another Formula in the same formula tool that would calculate the sheet names for rows 7 and 8 based on your condition. The Find and Replace tool works well for matching words, but it won’t match logic unless it’s typed out the same way

Chandrashekarb · Answer

Hello,

Any solution for it?

Regards,

Chandrashekar B