copy and paste code

[mesho]

I am having and excel workbook with 4 sheets named as entry, accident, traffic and nearmiss

what I am looking for is a code that will help me to do the following
1. if cell D1 in the entry sheet is reading as accident copy the total of record and date info that will be in G15 and F15 to next avaiable row in the sheet named as accident

2. if cell D1 in the entry sheet is reading as traffic copy the total of record and date info that will be in G15 and F15 to next avaiable row in the sheet named as traffic and do the same for nearmiss

appreciate if anyone could help.

[royUK]

The best way is to have one data sheet with an extra column for entry type. Then you can filter by that column

[mesho]

if we use one sheet along with the entry sheet would that still require a code?