Need Help on this one i only want to have sample on how to copy and paste some data which i dont have from sheet 1 to sheet 2 because i have 60000 line and some data which i have and some i dont so i only need to grab what i dont have from sheet 1 to sheet 2 using vba is it possible?
Do all cells have to match or just the first column to determine what is missing from Sheet1.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
all cell have to match if missing a data in sheet 2 then it will get from sheet one and fill it inside sheet 2
Anyone if other solution's?
Yes, there are some which are sheet2, but not sheet1. This make sense. Do you want to copy data which are in sheet2, but not in sheet1 INTO sheet1?
It is not clear.
All data which are in sheet1 are in sheet2, so what is missing?
I know you are comparing each row. Which data are copied from which sheet?
Yes just like what u said from sheet 2 to sheet 1
Try the attached.
yea its what i wan but the file i show u actually is just sample cause the real wan the file size is too big to fit in here and by the way its a long vba programming code i wish understood it
The code could cope with speed of 100k rows, depending on your CPU. As long as your data format remain the same, the code should work. If your data format is different, you need to attach a sample, which mimics your real data.
oo ok sure wait let me take sample from my worksheet
I will be off-site very shortly, but will check in my message at some point tonight.
Hey AB33 is it possible i send you the file thru other places like gmail?
You need to upload the file here -
To Attach a File:
1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks