[Solved] Copy values into a text template

[awascholl]

I'm using an accounting software that allows you to take vendors and tell it how to categorize them. This spreadsheet is an export of the existing rules, and it allows me to edit the file and import new ones to save time.

The one thing that doesn't save time is that I need to manually type both the rule name and category (Columns A and B), into Columns C and D, respectively.

My goal is to be able to type in new rules into Columns A and B, and then C and D would update.

Is this possible?

Edit: Changed subject, was Make variables from one column post into another  Make your post understandable by others  -- MrProgrammer, forum moderator

[MrProgrammer]

My goal is to be able to type in new rules into Columns A and B, and then C and D would update.

Thank you for your attachment. In mine, fill columns C and D down as needed to match A and B.

202511032148.ods

(13.71 KiB) Downloaded 99 times

If this solved your problem please go to your first post use the Edit ✏️ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know