Codes to long Possible Array may help ?

Please Login or Register  to view this content.

Rather than all those Ifs, try: Select Case

Thank you,

but not sure how that will work. But I will try...

When someone picks Jan 09 for example the script should take the values from cells c77 to n77 and place that value in c26 to n26 and also take the values from cells c102 to n102 and place in c54 to n54

However if someone were to pick Feb 09 the data should move down one row so the example would look like c78 to n78 data displays in c26 to n26 and c103 to n103 data displays in c54 to n54

So that data will always display in c26 to n26 and c54 to n54 only where the data is pulled from should change by the value in the combo box?

Hope that is a better explanation.

Thanks for any help, Mike

Originally Posted by Shijesh Kumar

Its just a part of code to give you a direction...

Please Login or Register  to view this content.

Hi and Thank you

I'm getting an error with this part of the code in red when I pick "Jan 09" in the combo box. The error is method Range of object_worksheet failed?

Thank You, Mike

Here is the workbook. However you will need to run the script below the one we are working with to populate the combo box for some reason the data keeps going away.

Thanks for your help, Mike

Working Now... Thank You for your input. I'm still amazed out how good you guys are!!!

Here is the code I ended up with to get what I needed.

Once again that you for your help!!!! Mike

Please Login or Register  to view this content.