Hi all, I was wondering if someone knew the workaround add-in certain columns to the transactions tab automatically. Currently, I am manually adding columns O and R with a Vlookup that I have to drag up every time new data is added in. This tells me what type of category it is and then goes down to another sub-level that I then use for data manipulation later.
I think I’m just going blank because I know that this can be done automatically but not sure how.
Can anyone help?
(I would embed an image for but some reason it isn’t allowing me to)