Print all records in 1 button click

[dgc050887]

Hi,

I made a payroll file with payslips that has drop down list of employee names, then looks up for the data depending on which employee I choose in the list. My problem is I don't have any idea with Macro or VBA and I would like to add a "Print All" button which prints payslips for every employee on the list.

Hope someone can help me.

Thanks in advance.

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[dgc050887]

Edited. Apologies for non compliance...

[bakerman2]

If Ben gives Go Ahead I'd post example file but for starters I'd loop through Employee Names and put one name after the other in cell which holds dropdown (no need for that anymore then)

[bakerman2]

First change topic title to "Print all records in 1 button click". This makes searching database easier for future users.
Secondly post example file with desensitized data so we can see what we're dealing with.

[dgc050887]

Here is the dropbox link to the file...

[Trebor76]

Hi dgc050887,

First of all well done in setting up your payslips like this. So many times I see a separate tabs for each different (in this case employee) item which just isn't the way to go.

This should do what you're after:

Please Login or Register  to view this content.

Note this forum allows attachments so there's no need to use file share sites in future.

Regards,

Robert

[dgc050887]

Wow! Thank you so much Sir Trebor 76. It is working perfectly!

Thank you also to sir bakerman2.

God Bless both of you.

[Trebor76]

Wow! Thank you so much Sir Trebor76. It is working perfectly!

You're welcome. If you could mark the thread as solved it would be appreciated

Regards,

Robert

[sintek]

Hi Robert

Thanks for info. I've attached my Workbook for perusal. Not sure if I would know how to incorporate a template coding. Works perfectly as is.

[sintek]

Oops wrong thread...My bad. Sorry guys