So I never post on these things...

But basically I've got a rent account set up that calculates where everybody is at organised into fortnightly periods with balances at the end of each period...
I want to be able to auto populate each section from another worksheet... where I can just drag and drop my bank statements in CSV form... and have the fortnightly fields auto populated... At the moment it's looking like some kind of INDEX/MATCH arrangement...
I re purposed a formula I got from the net...
But it's a little buggy...
Any ideas?