Move data automatically based on date

Copper Contributor

Hi all, 

I have a spreadsheet i am putting together, my intention is that data is inserted into a new row on "incident log" and then it auto populates the relevant sheet. So if a new row is added in April for example, it recognises that and adds it to the April log in the relevant year; adding a new line each time. 

I am doing it this way as i am trying to auto pull data out of that log. But i want to do that on a month by month basis, so how my incidents in April for example, were cuts.. or falls from height etc... 

If i can get the incident log to automatically spit out data to the right spreadsheet i can pull it all together and have graphs etc; basically i need very very little input from the end user as he isn't good on excel at all. 

Sample spreadsheet attached, tried to include a more complete copy but the upload space is small

I would appreciate any help that could be offered

0 Replies