Macro to add row if duplicate occur in a data table

Hi,

I hope someone can help I've been working on a attendance spread sheet. The purpose of the sheet is when I export the .csv time clock data I can paste it into the import tab, and from there it automatically sorts the employees into their respective team tab. The workbook has 10 tabs 1 summary tab, 6 team tabs, 1 employee tab, 1 supervisor, and 1 import tab.

The employee tab has the complete employee list with supervisor, and team.

The supervisor tab just has the list of supervisors for my data validation.

The import tab is where I copy the export from our time clock, I have a iferror statement with a nested vlookup to indicated if there's a new name on the export that's not recorded on the employee tab. And I have a macro to clear the export data.

The summary tab just has some pie charts reporting out on absents.

The team tabs do the heavy lifting in this workbook. I'm using a index/match formula to pull the members of each team followed up with a if statement with a nested vlookup to determine if a certain team member is present.

Here's the issue it's quite common for someone to have multiple punch in's and punch out's during the coarse of a day. for example if someone punches out for lunch it will create two punch ranges in the export 8:00 - 12:00 and 12:30 - 4:00. Some people of more punch ranges.

What I need is a macro that if a double plus punch in a range occurs it adds a row to the team tab copies the data over for the row and copies the team entry for the row as well.

Can anyone please help me with this