Take data in one sheet and merge it into a form on another sheet???

**Speedyjrr** · 05-27-2013, 08:35 PM

I am trying to take the data on the sheet called "monthly totals" and have it merge onto the sheet called "report" for each of the employees I have data for. Is there a way I can do that or am I out of luck?

All I basically need to do is get whatever is entered into the "monthly totals" sheet to be placed in the correct cell on the "report" sheet for each employee. I think of it as like a mail merge in word but maybe I am taking the wrong approach.

Any help would be appreciated as I'm not very good with the programming part of the office products! : )

**FDibbins** · 05-27-2013, 08:41 PM

Will you be entering an empl name in D8?

**Speedyjrr** · 05-27-2013, 08:42 PM

Yes, in D8 on the report tab, it should take the employee Last, first, Mi from the monthly totals tab.

**Speedyjrr** · 05-27-2013, 08:45 PM

I suppose what I could do is make a sheet (report tab) for each employee but then I would have over 100 tabs. If I did that, then I guess I could run a macro to fill in the info on each employees tab, right?

**FDibbins** · 05-27-2013, 08:48 PM

My suggestion would be to create a helper column to combine the last+1st name+ initial, and then use a drop-down in D8 to input the name. Once you have the name, it should be a simple matter to use vlookup or index/match to pull the relevant data to where you want it?

**Speedyjrr** · 05-27-2013, 08:52 PM

Take a look at the attached workbook. I modified how the name would be inputted. I realized that I don't need those separated. So, is the vlookup hard to do once I figure out the drop down box?

**FDibbins** · 05-27-2013, 09:00 PM

Im out of time now (for a while), but take a look at the attached (I started this before you uploaded your modified version). It gives you the idea of how to proceed with this...

**Speedyjrr** · 05-27-2013, 09:13 PM

Thanks FDibbins. I'll take a crack at it and see what I can do! If I get stuck, I'll post the workbook back here! Thanks for all of your help!

**Speedyjrr** · 10-27-2013, 05:54 PM

Greetings - I know it's been awhile, but I am still working on this little project.
I have the main part of the spreadsheet working correctly and now I am onto the report part.
Does anyone know how I can make a macro to take the data in the "Monthly Totals" tab and have it populate in the correct cells on the "Report" tab for each employee? I only have 3 in there, but when I'm done I will have over 100 and I thought I could have excel run the macro, put the info in the report tab in the correct cell and I could print off each employees sheet. Maybe this can't be done, but its been way too long since I have worked with Macros and the excel help book I have isn't providing much help!

Thanks in advance for your time in help on this little project.