Staff Monitoring results that creates a new workbook of data with tabs per employee

Hi I really hope someone can help me,

I Need help re writing my Macro so each time the button is pressed it copies range B4:Q4 from the master workbook and pastes that data to each employee's personal workbook on a new line each time.. adjacent to the months in the table

i hope this makes sense and thanks in advance for your support!
Chris

*****Update****Sorry i dont think that was very clear at all in my original question and i apologize.

Any way, I have progressed somewhat with the actual workbook and am happy with its look. The only thing i'm REALLY struggling with the final part of the code. (pasting to a new line/row each time the macro button is pressed adjacent the date ("b4") in new workbook) i can run my current macro to paste once on the first line (B4) only at present and think this must be such a simple problem to solve but i am out of ideas?!

I have created a separate workbook's for each employee, and have 1 master spread sheet (MONITORING - V3) with the locations they work - to input all of my monitoring data in. What i am trying to do is.. when i press the Run button it copies cells range B4:Q4, B5:Q4, B6:Q4, B7:Q4, B8:Q4 and pastes each line to their correct personal employee's workbook on a new row each time the macro's run - adjacent to the month, this way
slowly building a performance monitor.

PLEASE HELP! PS I HAVE UPDATED THE ORIGINAL XLS UPLOAD TO SHOW WHAT I HAVE CURRENTLY AND 1 EMPLOYEE WORKBOOK( SAMPLE DESTINATION WORKBOOK)

attached are samples of the docs, Monitoring -V3 is the master and Steve Stats is the destination for line B4:Q4 etc

thanks again in advance, i hope i get a reply

1) You need each row on each sheet of the Master document to transfer the one row that has a specific name to the workbook of that same name?
2) No name is repeated twice on two sheets in the master
3) In the named workbooks, the data must be pasted in the row that matches.... which date? What is the logic for knowing where it goes?

Hi,

thank you so much for replying, i'm so pleased. I'm very sorry if ive confused you please allow me to summarize:

1) yes exactly - I need these rows on the master document copied for each member of staff (i.e steve B4:Q4 - Carly B5:Q4 etc) then have this data transfer to a new workbook in that person's name (I.e Steve's Stats) underneath a heading i have created within that destination workbook.. this just so happens to be B4 aswell on the destination employee workbook. I have tabs on the master with the different office locations my staff are based, but the same rules will apply.. i was going to copy the code to create a button on each location tab? and just run the macro (modified with new filepaths) once for each location? is this a bad idea or inefficient.. i would be compiling the stats for all staff at one time so could well run all stats at once.

2)I can confirm no name is repeated twice on the master

3) well i only compile stats on each employee once a month you see .. i never really thought about a date within the master sheet, now you have said it i'd be great if i could specify the date the stats run was taking place and then for the macro to recognize a destination for said data.. thank you that's very helpful

i was just thinking to copy and paste to a new line under each paste, this way populating down the months

does that make any sense, again your more than helpful.. thank you

Your sample STEVE-STATS workbook shows all those dated prefilled. That's fine, it's just more a little more plumbing to teach a macro to go find a specific row by the date. We'll add a popup to allow you to enter a date, and I'll have it prefilled with THIS month's date. Or should it be last month's?

Also, there's really no reason to write a different macro for each sheet. You can put a button on each sheet, but attach them all to the same macro.

Lastly, I'm not going to put in any data checking, so when the proper date-row is found in the target sheet it will paste the new data in there even if there is data there already. This way, you can "update" the stats in the original sheet and send them out to the client sheets again with no fuss.

Give this a try:

Please Login or Register  to view this content.

Glad to help, now pay it forward. This week help someone extra more than they expect.