Copy data from range to another tab.

[ricunger]

I am having hard time figuring out how to copy data from one tab to another with a macro enabled button. On the "Pick your Shift" tab I would like to enter an employee id into cell C5, number of days in D5, and letters into D8-J8 & D9-J9. Once that has been entered i would like to click the button assigned with the macro to look up and match the emp id in C5 against the tab "Candidate Master" column B and copy the information within the same row. So the data should be pasted as follows D8-J8 to columns F-L, D9-J9 to columns M-S, and D5 to E.

I appreciate any help provided and will be sure to give feedback for those who help out!

[JOHN H. DAVIS]

Can you attach a sample file? Click on Go Advanced scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

[ricunger]

Sure thing! Thanks a million!

Pick Your Shift Tracker.xlsm

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

[ricunger]

Thank you it works great John!! Is there a way to have a message popup if the candidate number is not found?

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

[ricunger]

Thanks a million! Ill be sure to pick apart the macro to help me gain the knowledge to write it myself if needed again!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

[ricunger]

Thanks! Solved.