+ Reply to Thread
Results 1 to 8 of 8

copy data range and paste to worksheet selected from combobox

  1. #1
    Registered User
    Join Date
    03-10-2021
    Location
    USA
    MS-Off Ver
    2021
    Posts
    25

    copy data range and paste to worksheet selected from combobox

    Good evening! Looking for some help.. I am working on a workbook for payroll.. the workbook is set up as follows:
    Sheet 1 "TimeCard" : This worksheet has a data range set up for clock in/ clock outs for each day of the work week. The range of data needed is D9:I15 I have a combobox (started with a data validation drop down list... not sure which will be better yet) that lists each employee who will be clocking in and out. There are two buttons at the bottom, "Accept" and "Reset"
    Sheet 2- Sheet 19 "Name" : Each worksheet following "TimeCard" is named for an employee that can be selected from the combobox or data validation list.
    Last sheet "Employees" : Simple one column data range named "EmpNames" so that the combobox or data validation set can be easily updated

    ****Objective****

    Input clock times into the master data table-- Worksheet "TimeCard"/ Range (D9:I15)
    Select a name from the combobox or data validation list
    Click "Accept" -- pop up message box "Submit time card for ___employe name__?"
    YES: Data range is pasted to the worksheet selected from the combobox or data validation list
    Message "Timecard for ____employee name___" submitted!" Then the data range should reset and clear out for the next employee's input
    NO: Close the pop up message box, leave everything as it is
    Click "Reset" -- pop up message box "Clear and reset time card data?"
    YES: Data range clears
    NO: Close the pop up message box

    Any help would be greatly appreciated!
    Attached Files Attached Files
    Last edited by readysetgo; 03-11-2021 at 01:02 AM.

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: copy data range and paste to worksheet selected from combobox

    please provide a desensitized workbook as per the yellow banner above so we may help you further.

  3. #3
    Registered User
    Join Date
    03-10-2021
    Location
    USA
    MS-Off Ver
    2021
    Posts
    25

    Re: copy data range and paste to worksheet selected from combobox

    sample workbook now uploaded-- thank you!

  4. #4
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: copy data range and paste to worksheet selected from combobox

    Here you go

    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: copy data range and paste to worksheet selected from combobox

    Oops, here is code with Reset button coded aswell

    Please Login or Register  to view this content.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    03-10-2021
    Location
    USA
    MS-Off Ver
    2021
    Posts
    25

    Re: copy data range and paste to worksheet selected from combobox

    This works beautifully!! Thank you so much! Is there a way to fine tune it so that after the data is pasted to the employee sheet, the .tc range F10:I15 resets and the combo box in G6 resets also??

  7. #7
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: copy data range and paste to worksheet selected from combobox

    The Accept code has been updated to clear the page after data entry.

    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    03-10-2021
    Location
    USA
    MS-Off Ver
    2021
    Posts
    25

    Re: copy data range and paste to worksheet selected from combobox

    I am so impressed-- thank you for organizing my tangled web of thoughts! WELL DONE!! Thanks again!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy, paste and transpose selected data to new worksheet based on conditions
    By Grilleman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2019, 12:59 PM
  2. Copy data in Range and paste into selected column
    By goeman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-18-2018, 03:47 PM
  3. Filter range and copy selected column visible data and paste other sheet
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-19-2017, 11:37 AM
  4. Copy & Paste Data from Selected Worksheets to One Worksheet
    By wmetz1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-19-2015, 09:11 PM
  5. Replies: 1
    Last Post: 03-15-2014, 05:44 AM
  6. Replies: 2
    Last Post: 05-01-2013, 05:37 AM
  7. [SOLVED] Copy selected range of data and paste in new open workbook
    By coach.32 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-26-2013, 03:41 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1