macro pasting data in incorrect row

[rhudgins]

I would like to change the outrow in my formula to begin pasting data into row 31 on the DMM Averages Tab. Right now it is pasting the data into row 3 on the DMM Averages Tab. Can anyone help with this?

This is the past of the code that needs to be modified.

Please Login or Register  to view this content.

Entire Code

Please Login or Register  to view this content.

[Leith Ross]

Hello rhudgins,

The macro will now start at "A31", your second data table. The change has been made to the attached workbook.

Please Login or Register  to view this content.

[rhudgins]

Thank you for your help but the macro is starting at "A1" not "A31". Any idea why?

[Leith Ross]

Hello rhudgins,

Sorry about that, I was in a bit of a hurry. 30 needs to be added to OutRow because Match returns the relative position in the Array. The array now starts at row 31 but the first match on row 31 will return a 1 because it was found in the first row of the array.

Please Login or Register  to view this content.

[rhudgins]

Thanks this is perfect.

One more question. The range of data will expand over time to (1, 18), (1, 19)..ect and ("B36:S36"), ("B36:T36") ect...

Is there a way to change this part of the code so that I will not have to constantly edit the macro anytime my range of data expands?

Please Login or Register  to view this content.

[rhudgins]

Is there anyway that this can be done?