Adding data to multiple tabs

[chillingsince94]

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

[6StringJazzer]

Your explanation is sort of sketchy but I think you want this:

Please Login or Register  to view this content.

I assumed that the name in E7 is the same as the name of the worksheet (tab).

You said E7 but didn't say what sheet it was in. I assumed it was in PartsData, but if not then just change the sheet name above to match.

(ThisWorkbook is OK but not required. All references are assumed to be in ThisWorkbook.)

[chillingsince94]

Hi 6stringjazzer,

Sorry for the sketchy explanation.

I hope this might be clearer, please let me know if you need anything else.

We have one tab called input, in the input tab they fill the form in and then we have a button that adds it to a master data sheet called partsdata. which we use the SetDataWS= ThisWorkbook.Sheets("PartsData") to state the tab name

We now want to move away from this and have the data stored separately.

The below is how we would like it to work if possible.

For the user to carry on filling it out in the input tab, but now when they click the add button we want it to add the data to the tab relevant tab name based on the name they fill in on E7 on the input tab.

For example if they go into the input tab and put joe in cell E7 the data would be copied to Joe's tab and not the partsdata tab.

Thanks again for your help with this its much appreciated.

Thanks

[6StringJazzer]

In that case maybe this:

Please Login or Register  to view this content.