How to copy number of cells if two criterias are met

Hi,

So, I tought this was going to be an easy one, but I am really having a hard time with this one.

I have two cells that can have up to 8 values each (select value from a drop down list), and I have a big range (26 cells) that I want to copy to this sheet from another sheet if the criterias are met.

So, the code will be something like:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I have around 60 ranges I need to copy based on different different criterias, but right now, I am not able to copy one

Thanks for any help I can get with this!

Originally Posted by TMS

Might be because "50" is text as opposed to (just) 50 which is numeric.

Thanks for reply. I have tried without "" as well.

Hi! Of course I can upload a file! Thanks for showing interest Momps1!

The file should now be uploaded. I have cleared sensitive information and the VBA. I have tried to explain in the file what I want to do as well.

Originally Posted by Mumps1

Start by formatting all the numbers in red on Sheet2 as 'Number' with 8 decimal places or whatever number of decimal places you want. Next copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your Sheet1 and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. First select a value in E39 and then select a value in E41.

Please Login or Register  to view this content.

Oh man! That was GREAT! That code is so far from my level, I need to study it =)

So many thanks to you my friend!

Originally Posted by Mumps1

You are very welcome.

Hi!

So, I Have to ask for your precious advice again.
So, the code you gave do not change the values if I just change value E39 without changing E41. Is this possible?

Also, I tried to add another column with different values that can be seen in Sheet 2 (further down). I do not know what is wrong with the code.

I will put both here and hope for advice

Please Login or Register  to view this content.

Originally Posted by Mumps1

Try:

Please Login or Register  to view this content.

Remember to format all the numbers on Sheet2 as 'Number' with 8 decimal places or whatever number of decimal places you want.

Thanks again my friend! Works like a charm!

Just out of curiosity, why do I need to format the numbers with different decimal places?