Lost: How do I make a Macro to tabulate names and entries

[2014hunter]

Hi Excel geniuses,


I am new to using Excel's macro system. My manager asked me to create a spreadsheet that I can record training info on and generate reports with.
You can see the format I have so far with the attached spreadsheet. My goal is to have a Macro tabulate all the trainings for one person into a template on another sheet for easy access come time for year end reviews.

Here is the data:

100+ employees 50+ trainings a year. New spreadsheet each year. Using Excel 2010.

First sheet has name, date and training. I will sporadically input all the preceding data in as the year goes by.
Second sheet has a form that when I type in the employee's name, all his/her training pops up. This would be the best scenario. I tried something with mail merge, but that didn't pan out.

Any help would be appreciated.

Thanks!
Will

[2014hunter]

Ugh, my file won't up load...so here is a bit.ly to a Google Spreadsheet: http://bit.ly/1Lci8uM

[protonLeah]

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

make sure the xlsx/xlsm file is less than 1 mb or zip it and post the zipped version

[mrice]

Always best to attach a workbook example showing before and after so that potential responders don't have to guess at the format.

[2014hunter]

Did all the above...once I select the file (11.5kb), the blue spinning thing keeps going. Waited 30 minutes. Did not upload.

[2014hunter]

My apologies for the uploading issues... I'm not too concerned about formatting per se, just as long as the three data points tabulate.

[2014hunter]

I have tried uploading it for 1 hour...still shows a blue spinning icon.

[protonLeah]

Are you using Windows 10, I've heard there. is a problem? What browser are you using, I/m not familiar with a spinning icon? What step gives you the spinning/busy icon?

[2014hunter]

https://imgflip.com/i/s3g8y

Thanks for the help Leah!

This is what I get for a solid hour when I select a file to load (14.11KBS file size): See link above. I am using a HP laptop, Internet Explorer 7, with Windows XP OS.

[protonLeah]

I'm sorry, but I can't duplicate that error.

[2014hunter]

I got it! I had to switch computers, but it works now....would you mind removing\deleting this post please! Thanks Leah!

[vichopalacios]

Hi Will 2014hunter

I tryed to write down something just from your original axplanations
the link to the spreadsheet you put at the begining asks for permisions ! ¿???...impossible to check

Anyway, check the attachment to see if it is what you are looking for
There are some use instructions inside Sheet("Report")
Please coment us how it goes on

Viho_Trainings.xlsm

Vicho

[2014hunter]

Looks great man...thanks!

[FDibbins]

2014hunter, why do you want this thread? deleted? We normally just close a thread once it has been resolved. Others may have a similar problem and could be helped by this

[2014hunter]

The only reason why I wanted this post deleted is because I posted it in the "Professional Services forum" and didn't want to break any of the forum rules. If you think it would help someone, please, leave it up and marks solved. Thanks!

[FDibbins]

I will just close it, so you can continue on the CS forum

Thread closed