Consulting

Results 1 to 5 of 5

Thread: Copy & Paste from 1 WB to another WB

  1. #1
    VBAX Newbie
    Joined
    Sep 2021
    Posts
    4
    Location

    Copy & Paste from 1 WB to another WB

    i don't know why the same set of sets sometime works & sometime doesn't.
    If i erase my record from 100k row to just remaining 1 row of data. It works.
    I just don't know how to fix it.


    Is it malfunction of vba? any bugs / cache need to be cleared?


    Pls find. Thanks.
    Attached Images Attached Images

  2. #2
    VBAX Guru mancubus's Avatar
    Joined
    Dec 2010
    Location
    "Where I lay my head is home" :D
    Posts
    2,632
    welcome to the forum.
    see my forum signature for uploading sample workbook.
    PLS DO NOT PM; OPEN A THREAD INSTEAD!!!

    1) Posting Code
    [CODE]PasteYourCodeHere[/CODE]
    (or paste your code, select it, click # button)

    2) Uploading File(s)
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) (multiple files can be selected while holding Ctrl key) / Upload Files / Done
    Replace company specific / sensitive / confidential data. Include so many rows and sheets etc in the uploaded workbook to enable the helpers visualize the data and table structure. Helpers do not need the entire workbook.

    3) Testing the Codes
    always back up your files before testing the codes.

    4) Marking the Thread as Solved
    from Thread Tools (on the top right corner, above the first message)

  3. #3
    Knowledge Base Approver VBAX Wizard
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,387
    Attaching both files would be good. In the meantime:
    1. Is every row in the source file column F guaranteed always to have data in?
    2. Is every row in the destination file column D guaranteed always to have data in?
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  4. #4
    VBAX Newbie
    Joined
    Sep 2021
    Posts
    4
    Location
    Yes. Confirmed. Both always has rows

  5. #5
    VBAX Newbie
    Joined
    Sep 2021
    Posts
    4
    Location
    Copy data
    Sales WB.jpg

    Target WB
    Target WB.jpg

    Quote Originally Posted by p45cal View Post
    Attaching both files would be good. In the meantime:
    1. Is every row in the source file column F guaranteed always to have data in?
    2. Is every row in the destination file column D guaranteed always to have data in?

Posting Permissions

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