+ Reply to Thread
Results 1 to 5 of 5

Copy & Paste to a specific row in another worksheet and clearing data from the form

  1. #1
    Registered User
    Join Date
    08-23-2019
    Location
    UK
    MS-Off Ver
    Mac
    Posts
    3

    Copy & Paste to a specific row in another worksheet and clearing data from the form

    Hi,

    I am looking for any advise/help on the following...

    I am trying to work out how to write a VBA code in Excel to transfer the data to a specific cell in another worksheet.

    I have a front sheet that allows the person to enter data, with a drop down menu for the 4 other worksheets in the workbook. Then another one to select the location. Is there anyway that I can get the information to automatically go to the correct row in the workbook after clicking a button without losing the information once I clear the front sheet?

    I have another option of creating a page which all data will go onto one sheet then redistributed to the other sheets. I want to make it as user friendly as possible, the first option would be my preferred one but any advise would be appreciated.

    TIA

    K Stevens

  2. #2
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    1,827

    Re: Copy & Paste to a specific row in another worksheet and clearing data from the form

    You can upload your file by clicking 'Go Advanced' at the bottom of the reply box, then click 'Manage Attachments' and follow the menu. This will allow us to work with your actual data and formats to help resolve your issues. If your data is sensitve, then copy the file and substitute fake data in the one that is uploaded. If you have a really large file, you can delete all but a few rows in the uploaded copy. We just need enough to understand your data layout and arrangement of forms, tables, controls, etc.
    Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, click the 'Go Advanced' button, Then click 'Manage Attachements' and follow the menu.
    Thinking I am smart and knowing I am smart are two entirely different levels of schizophrenia.

  3. #3
    Registered User
    Join Date
    08-23-2019
    Location
    UK
    MS-Off Ver
    Mac
    Posts
    3

    Re: Copy & Paste to a specific row in another worksheet and clearing data from the form

    I have uploaded the file, No data in currently no sensitive data that I can think within the workbook. Thanks K Stevens
    Attached Files Attached Files

  4. #4
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    1,827

    Re: Copy & Paste to a specific row in another worksheet and clearing data from the form

    My first advice, if you want to use VBA, is to get rid of the merged cells. While it can be done, the current design of your worksheets is not conducive to simple macros to do what you want. The problem is trying to tie the functions to the staff categories. The Hospital and Ward are pretty straight forward and can easily identify the sheet and row you want to put the data in, but the column would take a bit more doing becaue of the different staff categories for the same service. Like I said, it can be done, but I am not going to spend the time on it to try and do it. Perhaps someone else will be willing to try it now that they can see what you are working with. Thanks for providing the link to your file, it saves a lot of time and explaning.
    Regards, JLG

  5. #5
    Registered User
    Join Date
    08-23-2019
    Location
    UK
    MS-Off Ver
    Mac
    Posts
    3

    Re: Copy & Paste to a specific row in another worksheet and clearing data from the form

    Thank you I will go through and amend the merged columns. Then try and rework the vb code

+ 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. Copy Data from One Worksheet and Paste it into a specific Worksheet in a different workboo
    By kingsdime29x in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-22-2018, 02:09 PM
  2. Replies: 5
    Last Post: 10-29-2017, 11:12 PM
  3. Copy and Paste Over Existing Data without clearing the sheet
    By guitarsweety in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-11-2017, 02:19 PM
  4. Replies: 0
    Last Post: 10-08-2013, 02:58 PM
  5. Copy Data from form field and paste into worksheet cell
    By azhark in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-18-2013, 04:47 PM
  6. Replies: 0
    Last Post: 11-06-2012, 06:44 PM
  7. Populate from user form then copy & paste to another worksheet
    By zimbo109 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-24-2010, 12:41 PM

Tags for this Thread

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