Hello all,
I copy rows of data according to the entries in Column C and H and paste them in to the relevant sheets based on ranges.
For example in Column C there are dates, which I separate off based on which financial year (the year begins 01/04/YY and ends the following year on 31/03/YY) it belongs to. So an entry in Column C with the date 14/01/08 would be copied to Sheet "2007-08" and date 07/09/08 would be copied to Sheet "2008-09".
Similarly in Column H there are amounts paid and these are separated in to sheets according to payment bands, i.e 0-£500, £501-£1K etc.
So the data is copied and separated twice, once according to the date in Column C and the second time according to payment in Column H.
Thanks in advance for any help provided.
Bookmarks