Hi All,

I have a macro that takes data from a data input sheet and adds it to a data sheet. They now want instead of one data sheet for everyone separate ones per person.

The code I have for this is SetDataWS= ThisWorkbook.Sheets("PartsData") (Partsdata is the data sheet we copy and paste the info from the input sheet.

Instead of going to Partsdata I would like it to go to the tab of the relevant person. we input who undertook the task in cell E7. Each one of the people have there own tabs.

So for example if it was for Jane it would go to Janes tab and if it was for Bob it would go to Bobs tab.

Any ideas how this could be done. Thanks