SUMPRODUCT

[montecarlo2012]

Hi, after hours of searching about sumproduct in the way I got in the code, realize that nothing help me. Please any suggestions here will be appreciated.
this is the line of my problem :

.Rows(0).Formula = "=SUMPRODUCT(--(" & rngData.Resize(NoRows - i, 1).Address(0, 0) & "=" & .Columns(1).Address(0, 0) & "))"

this line give me on sheet 1 the result in the following way:

until here

and between the are one column space

and in this way go until GP in other words this loop create 35 arrays, I would like (" IF THAT IS POSSIBLE"), instead going to the right, would be awesome if I can see the same information on sheet 2 in the way is illustrated in the following image:

for this one I have to write for every line sheet1!I2 and so on, and is 10 work books to do the same,

thank you for reading this.

 

[montecarlo2012]

is true, thank you.

 

[montecarlo2012]

Thank you for calling my attention I didn't see what you point out, sorry. OK so first thing first:

,

so the formula read sheet 1 and sheet 2 is empty.

 

[jasonb75]

A also said

Start with an XL2BB sample (See link below, screen captures are of no use)

Obviously the link that I quote is in my earlier reply.

If I see any more screen captures of data (use XL2BB), code (use code tags), or text from earlier posts (use quote tags) then I will remove your thread from my watch list and not provide you with any further help.

 

[montecarlo2012]

thank you jasonb75 my excel and my computer have problems, I try xl2bb, nothing, peltzier nothing. so I give up. you give me a real good offer, I loose. somehow some day I will find a real tutorial.
so thank you.