Forum Discussion
Copy data to different columns by name on same sheet
Excel shall know somehow for each payee to each category it corresponds. That could be additional table with such mapping. When you may add formulas to categories columns (INDEX/MATCH or so) which based on this information returns sums from column D to categories columns.
And better main info also to organize as Excel table to, as a minimum, autofill formulas when you add the information.
Thanks for your reply Sergei.
One off payees and their amounts will need to be c&p into the correct column. ie a one off payment to British Airways etc etc.
What I'm wanting is to copy those sums/figures from regular payees into a specific column.
How do I do that ?
But again, what if the formal logic behind, how do you know into which column and how to explain that to Excel.