Dynamic select field

[Jes_Li]

Hi,

I have an Excel with about 40 fields. I want to select a field has a record equals "Account" and a field has a record equils "Date" (the ones I highlighted). How can I select them in a dynamic way? 

There are 70 sheets with "Account" in different fields and different rows. But for every sheet, only one field has "Account" key word and only one field has "Date" key word. 

Before:

After:

Thanks.

[Htaneja2]

you need the name of row or column for the field that includes the specified string??

[Jes_Li]

Hi Htaneja,

Thanks for your reply. I just need to select those fields(with a keyword "Account" and "Date" and unselect other fields.

Just like Select Tool, but in a dynamic way, because I have 70+ sheets and each sheet has different fields include "Account" and "Date", I can't put 70+ Select Tools to select those 2 fields in each sheet and rename them as "Account" and "Date". Hope it makes sense.

I upload a sample for your reference.

[Jonathan-Sherman · Accepted solution]

Hi @Jes_Li,

I believe this is what you're trying to achieve?

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan