+ Reply to Thread
Results 1 to 13 of 13

Copy and Pasting dynamic data into blank rows and of another sheet

  1. #1
    Registered User
    Join Date
    03-17-2012
    Location
    Mississauga,Ontario
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    75

    Copy and Pasting dynamic data into blank rows and of another sheet

    I am using the below code to import certain (dynamic)rows from a emailed sheet to a sheet on the next blank row
    however when I am importing the date and time it is only pasting on the first row but not on subsequent rows if the initial import is multiple rows.
    So I am trying to add the date and time and include the sheet name of the original sheet on all the rows of the import.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,222

    Re: Copy and Pasting dynamic data into blank rows and of another sheet

    I do not see the copy method in your code, only paste command

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-17-2012
    Location
    Mississauga,Ontario
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    75

    Re: Copy and Pasting dynamic data into blank rows and of another sheet

    Please Login or Register  to view this content.
    is what I am using..Since the sheets are emailed to a secondary mailbox , they are opened temporarily ,and the email saved on the server.
    is there a better way??

  4. #4
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,222

    Re: Copy and Pasting dynamic data into blank rows and of another sheet

    Hmm!
    you are copying and then open and paste the selection, but where is the source data sheet on the code. Or are you copying from the active sheet?

  5. #5
    Registered User
    Join Date
    03-17-2012
    Location
    Mississauga,Ontario
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    75

    Re: Copy and Pasting dynamic data into blank rows and of another sheet

    yes I am copying from the Active sheet.

  6. #6
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,222

    Re: Copy and Pasting dynamic data into blank rows and of another sheet

    A long way to go:
    Separate the source book and destination book.
    Source Book: You should have this workbook, then sheet name, then range
    Put this at the top of the code
    Please Login or Register  to view this content.
    Then select range.
    Let's say
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    03-17-2012
    Location
    Mississauga,Ontario
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    75

    Re: Copy and Pasting dynamic data into blank rows and of another sheet

    done!

    but I am running the code from my personal macro sheet so will it apply to any workbook opened.

  8. #8
    Registered User
    Join Date
    03-17-2012
    Location
    Mississauga,Ontario
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    75

    Re: Copy and Pasting dynamic data into blank rows and of another sheet

    sorry when I said Done! I meant I in-putted the code but its not doing anything..
    any help with the post ?

  9. #9
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,222

    Re: Copy and Pasting dynamic data into blank rows and of another sheet

    Now, we need to set up the destination workbook

    Set wbk = Workbooks.Open(Filename:="Z:\Test.xlsx")

    What is the name of the sheet from the Z/Test?

  10. #10
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,222

    Re: Copy and Pasting dynamic data into blank rows and of another sheet

    We then need to link the wbk with strName and input box

  11. #11
    Registered User
    Join Date
    03-17-2012
    Location
    Mississauga,Ontario
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    75

    Re: Copy and Pasting dynamic data into blank rows and of another sheet

    there are two sheets based on the inputbox sheet1("over") and sheet2("short")

  12. #12
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,222

    Re: Copy and Pasting dynamic data into blank rows and of another sheet

    Please Login or Register  to view this content.
    'do something

  13. #13
    Registered User
    Join Date
    03-17-2012
    Location
    Mississauga,Ontario
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    75

    Re: Copy and Pasting dynamic data into blank rows and of another sheet


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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