VBA Sumproduct Issue

[mowens74]

Hi,

I have searched and searched and cannot find an answer to this....

I have the following code on Sheet2

Please Login or Register  to view this content.

Which works but what I need to do is have this code on Sheet2 but for the 'Sumproduct' command use data on Sheet1. Please help.

Thanks

[zbor]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[stanleydgromjr]

mowens74,


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Please Login or Register  to view this content.

[zbor]

stanleydgromjr,
Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc

I will restore your post when user add code tags.

[mahaveersomani]

please upload a sample file so that i can help u

Regards
CA Mahaveer Somani

[mowens74]

I have resolved this by using

Please Login or Register  to view this content.

Thanks.

[JosephP]

you could also use

Please Login or Register  to view this content.

[mowens74]

Cheers, makes it a little neater....

[stanleydgromjr]

mowens74,

Thanks for the feedback.

You are very welcome. Glad we could help.

Come back anytime.


zbor,

I am very sorry about not following the rules.

When I answered mowens74's request I did not see your reply to mowens74.

I am trying to get comfortable with my new laptop and Windows 8 64 bit.


Everyone have a great day,
Stan

[zbor]

zbor,
I am very sorry about not following the rules.
When I answered mowens74's request I did not see your reply to mowens74.

I assumed since 7 minutes passed.. Sometimes that's not enough... That's why I didn't give you infraction
But you should see that code tags are missing