Hi,
We need to automate a number of tasks that are manually keyed daily.

We have a spreadsheet with columns headed Date, Total, UK, USA, Italy, France/ etc (a total of 15 countries).

Every day we have visits from around 100 countries. We collate visits from countries into the 15 headed categories above (these categories remain permanently fixed). We then discard the remaining countries, and save the information for that day. At the end of each month we have all our daily visits collated and we can then just manually total them up. We then give this information to the senior staff for review.

All the headed information is on sheet1, and all the new daily data is collated on sheet 2.

This will save a lot of time going forward if someone can help.

Regards

NoeBol