I'm newbie in vba macro.
Currently i facing a problem using the sumproduct in my macro.(i'm using excel 2003)
My logic is like that is sheet1(label no) = sheet 2 (label no) & sheet 1 (amount) <>sheet 2(amount) then copy sheet 2 data into sheet 3
. My coding is below but i still can not copy them into sheet3. Anyone have any idea.
Please Login or Register to view this content.
try this
replace sumproduct line as
does it helpPlease Login or Register to view this content.
I am not an expert. better solutions may be available
[email protected]
It can not work.
Last edited by Cutter; 07-21-2012 at 12:36 PM. Reason: Removed whole post quote
Question1): Why not?Please Login or Register to view this content.
Question 2): Does you're sumproduct works in Excel?
Then you can record the VBA code with the macro recorder.
Is this the same youre working on?
http://www.excelforum.com/excel-gene...e-cateria.html
Last edited by oeldere; 07-21-2012 at 04:35 AM. Reason: Is this the same youre working on?
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks