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.
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)
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.
Yes. Confirmed. Both always has rows
Copy data
Sales WB.jpg
Target WB
Target WB.jpg
Originally Posted by p45cal
Posting Permissions
Reply With Quote
