Gary has attended:
Access VBA course
Excel VBA Advanced course
VBA statement for Excel 2003 - To copy information by different
Good morning,
I have an offence code spreadsheet, these are grouped by an Integer value in the Offence Group column on the spreadsheet. I would like a bit of code that basically knows which group it is sorted by on the column and then if there is a new offence it inserts a new cell and updates a linked spreadsheet that I have namely G20 offences codes.
I have tried a few different ways but I have multiple debugging errors.
So, basically it recognises the integer value i.e. 15 and then if there is a new offence it inserts a new row underneath the group and then transfers this information to a new spreadsheet.
If you could help me on this urgently that would be greatly appreciated.
Thanks,
Gary
