I have a "TAKINGS" Worksheet with the table "TAKINGS", it has 8 column headers;
DATE, STAFF, QTY, DESCRIPTION, SIZE, TOTAL, DEPT, EFTPOS.
With contents like;
30/07/2017, Neil, 1, WESTEND, PINT, 7, ONTAP, Y
30/07/2017, Neil, 1, XXXX, PINT, 7, ONTAP, Y
30/07/2017, Neil, 1, PALEALE, PINT, 7...