Okay so I I have uploaded a mock up...
I've changed names but these are based on actual entries, but numbered to be sure that each entry is in fact a new entry... There is another section to this spread sheet, that adds up everyone's payments and derives balances and totals by searching the data that I am trying to auto populate now, But thats not relevant, What O need help eith is just autopoulating the fields from theCSV data...
I had a index/ match formula but it was buggy... which I copied into an earlier post...
The first entry is how thy all should appear... all entries need to be sequential greater than the previous date and < or = to the next date for each field.
In my attempt the formula reffered to the last date of the previous field, and then each reffered to the previous entry for the date, in that field, pbviously they all need to reffer to the end date of the fortnightly period... so that no entries exceed it.
I'm stumped...
Any takers?
Cheers,
Q
Bookmarks