Summing of Matching Values for condition

[bdb1974]

Hi all,

I need some assistance on coming up with a VBA Code to sum conditional matching variable values.

On Sheet 1, I have numerical values in column A
On Sheet2, I have the same numerical values listed in column A
and for some rows I have some numerical values from column A in column T.

On Sheet 1, I have integer values in column X.
For the corresponding numerical values found on Sheet2 (column A&T) that match the values in column A of Sheet two I need to sum the two integer values found in column X into column Y of Sheet 1.
This will happen if column U of Sheet 1 contains a specific value.
For instance if value "W" is in column U.

Here's an example workbook of values and the resultant found that should found in column Y of sheet1.

If anyone help w/ a basic code structure, then I think I'll be able to substitute into my real workbook.

Thanks,

BDB

[DonkeyOte]

Hmm... in *theory* you can do this with formulae assuming the values listed in Col A on sheet 1 do not appear within range B:S on Sheet2 ? eg:

Please Login or Register  to view this content.

[bdb1974]

A formula would not be a good option as I will always have a few thousand rows of data. Plus my values are all variables on sheet1.

[bdb1974]

Any chance of some help on this?

[bdb1974]

I've decided it maybe easier (for me at least) to bring all the values to a "working_page" before outputting the actual value I need.
I've put together the following code. However, I'm not sure if the last bit is summing the values that I need summed. The part of code in question is in red. It should sum the values for I in columns R & U.The output should be to column AC on the same sheet "Working_Non_Completed"). I'm getting some values which I have yet to figure out where they're coming from. Can anyone look at the code and please tell me?

Please Login or Register  to view this content.

Thanks for any help I can get.

BDB