Hello! I hope you are well, and in a pleasant frame of mind.
I would like to automate correcting row entries. Whether it’s a macro or a script, I’d like to run a routine that:
- Looks in each row for specific values in specified cells (specified columns);
- When those values are found, writes specific values (text) in other specified cells (specified columns).
I imagine the logic would be “If the value in [column x1 name] = [value a1] and the value in [column x2 name] = [value a2] then write in [column x3] [value z1], write in [column x4] [value z2],…”
How may I go about this?
I have next to zero experience writing code or macros.
I appreciate your response. Thank you.
Your question here reminds me of my days in algebra
But I do think AutoCat can do what you’re asking.
You’d want to read up and experiment with the Advanced Rules. You can have it look at multiple columns at once to see if it matches a filter criteria, you can also created “multi-criteria” filters on a single column. And it can write out data to columns other than the Category column if they exist in your AutoCat sheet too. You can experiment easily by toggling on the Advanced Rule Builder setting in the sidebar from Tiller Money Feeds > AutoCat
AutoCat advanced rules help doc