Please Login or Register to view this content.
So here is the situation copying workbook i have it but what i want is to fill in the blank.
Exemple: workbook 1 has part numbers and workbook 2 the same and i want to sum them in workbook total. as you can see i can not only copy paste.Attachment 292807Attachment 292808Attachment 292809
Last edited by K-Ching; 01-27-2014 at 01:49 AM.
Hi K-Ching
In your sample Total Workbook the Part Numbers already exist. Is this true in the real world?
Your profile shows Excel 2003 yet you've attached .xlsx Files...please change your profile as appropriate.
Will there be ONLY two Source Workbooks or could there be more than two?
Last edited by jaslake; 02-02-2014 at 01:51 PM.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Hi K-Ching
This Code is in the attached. Change the two lines of Code as indicated...CTRL + z to fire the CodePlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks