Results 1 to 7 of 7

Macro for button won't transfer data to another sheet

Threaded View

  1. #1
    Registered User
    Join Date
    10-16-2017
    Location
    Yorkshire
    MS-Off Ver
    Office 10
    Posts
    3

    Macro for button won't transfer data to another sheet

    Hello friends,

    I am currently trying to write a macro for a button to automatically populate data from one sheet to another. Basically, guests attending this big event will receive a link and will be able to access the first worksheet. They enter the data and click the button at the bottom. The macro assigned to that button will then populate the guestlist. I have searched so many different codes and have ended up with this one. But it keeps coming up with an error. Can someone solve this for me:

    Sub Copy()
     
       Dim BlankRow As Long
       BlankRow = Sheets("Guestlist").Range("B65536").End(xlUp).Row + 1
     
       Sheets("ITC Open Day Return Sheet").Range("D5").Value = Sheets("Guestlist").Range("E" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("D7").Value = Sheets("Guestlist").Range("F" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("D9").Value = Sheets("Guestlist").Range("C" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("F5").Value = Sheets("Guestlist").Range("B" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("F7").Value = Sheets("Guestlist").Range("D" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("D13").Value = Sheets("Guestlist").Range("G" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("D14").Value = Sheets("Guestlist").Range("H" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("D15").Value = Sheets("Guestlist").Range("I" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("D16").Value = Sheets("Guestlist").Range("J" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("D17").Value = Sheets("Guestlist").Range("K" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("D19").Value = Sheets("Guestlist").Range("L" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("D21").Value = Sheets("Guestlist").Range("M" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("D26").Value = Sheets("Guestlist").Range("N" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("D29").Value = Sheets("Guestlist").Range("O" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("D32").Value = Sheets("Guestlist").Range("P" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("F26").Value = Sheets("Guestlist").Range("Q" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("F29").Value = Sheets("Guestlist").Range("R" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("F32").Value = Sheets("Guestlist").Range("S" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("D36").Value = Sheets("Guestlist").Range("T" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("F36").Value = Sheets("Guestlist").Range("U" & nextRow).Value
     
       nextRow = Sheets("Feeding and Accommodation").Range("B65536").End(x1Up).Row + 1
       Sheets("ITC Open Day Return Sheet").Range("D9").Value = Sheets("Feeding and Accommodation").Range("C" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("F5").Value = Sheets("Feeding and Accommodation").Range("B" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("D44").Value = Sheets("Feeding and Accommodation").Range("E" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("D46").Value = Sheets("Feeding and Accommodation").Range("F" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("D48").Value = Sheets("Feeding and Accommodation").Range("G" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("D50").Value = Sheets("Feeding and Accommodation").Range("H" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("D52").Value = Sheets("Feeding and Accommodation").Range("I" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("D63").Value = Sheets("Feeding and Accommodation").Range("J" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("D68").Value = Sheets("Feeding and Accommodation").Range("K" & nextRow).Value
       Sheets("ITC Open Day Return Sheet").Range("D72").Value = Sheets("Feeding and Accommodation").Range("L" & nextRow).Value
     
     
    End Sub
    Last edited by titchroberts; 10-16-2017 at 08:34 AM. Reason: Change title

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Debug this code
    By ShandArchive in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-17-2017, 09:25 AM
  2. Debug code
    By Human2014 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-03-2016, 07:27 PM
  3. Error in the code please debug it
    By kalyaaans in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-22-2014, 10:28 AM
  4. VBA Code Runs in Debug Mode But Returns Type Mismatch Error Outside Debug Mode
    By valerie.k.chiang in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-24-2014, 03:48 PM
  5. [SOLVED] Debug: How to debug this code?
    By reach78 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-25-2013, 07:16 AM
  6. Debug the Code
    By macrogeek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-17-2011, 06:45 AM
  7. HELP, trying to debug this code...
    By twofootgiant in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2011, 12:05 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