Userform code

hi, ytrehguodleinad, can you post sample workbook showing original data and result you need to obtain?

I created an example file with what I am looking for, I am basically done gathering the information ytd for the group, its creating a user form to allow others to input it and go to the correct place is my struggle,

also I included something on the first page, I am having trouble with having the first sheet pull from the additional sheets based upon the month selected, I typically use if statements but in this case there are more than seven months.

Any help would be appreciated.

hi, ytrehguodleinad,

1. Re: pulling data from each agent sheet, check attachment, run code "test".

2. Re: putting agent's metrics through userform, what's the point to make it through userform manually? You can create a sheet with "raw" data of all the agents for update, the code will put it correctly to every agent list. If it's acceptable, please post how that info may look like.

Attached is my updated example using the macro you created, which was excellent. It worked perfectly no matter how many different sheets I added (This is important as people come and go) However, when I made a master sheet per your request, the macro came back with an error. It is important that I be able to add additional sheets and subtract as people come and go. The new sheet is trending information, I would like the user form to input into this specific sheet depending on the agents name and the month selected, then they could input the data and hit save. This would then push to their individual sheets. ( right now I have it set that the opposite flow is occurring for a visual representation. The reason I need this is that some of the users of this will not be comfortable inputting into the proper cells. I think after viewing what I did you will understand exactly what I am trying to do. Any help would be appreciated.

please check attachment, the code has been revised. If it's OK will add userform

userform added

This is exactly what I wanted. You are fantastic. The only issue I am having is when I input the numbers its not allowing me to put in a %. If i format the receiving cells as a percentage it makes 100% 10000% etc. Is there a way around this?

Thanks!

please check attachment. If values that can be entered are limited from 0 to 100, the code should be amended to take it into the account

You are the best, thank you so much for all of your assistance on this, this is perfect. If i come across any struggles with this I will reach out to you.

ok, if you are happy with the outcome, please mark the thread as solved (see Forum Rules: http://www.excelforum.com/forum-rule...rum-rules.html for details)