I have a list of various payments in columns in a spreadsheet. At the end of the financial year (Australia) I must isolate a particular set of payments (e.g. SH or Interest) into new columns containing those payments only, beginning on 1/7/11 to 30/06/12 (Years change). I hope I have made myself clear TIA Terry
I have added the correct Excel file (I hope)
I have now added the file (Book 1a) with columns J, K, L & M to indicate what I want to achieve. In other words I want to separate out rows 5, 8, 13 & 16 etc. I hope I have clarified the situation and thanks for the reply.
Bookmarks