Forum Discussion
Copy data to different columns by name on same sheet
I'm putting several months worth of accounts onto a single spreadsheet. I copy and paste Cols A,B,C & D from the bank a/c, before c&p each amount into the relevant column, ie. BP fuel goes under "...
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.