Thanks for you reply.

Yes i think you are right. I will flip the tables around.

Its a little confusing as i may not have explained it right.

You see cells D27 to D38, there are three separate date (29/03 03/04 and 01/07) what i would need is:

column D all feed quantities arriving on the 29/03
column E all feed quantities arriving 03/04
column F all feed quantities arriving 01/07

I think i can do with two tables but i want to get it into one and i dont want to have to filter using the table drop down menu.