Forum

Sorry, I don't understand your question. Maybe you can give more examples and show us what is your expected results.

Hi Tex See if this helps. I assuming >10 is the rain fall. Sunny

Hi Dave You're welcome. Sunny

Hi Melinda What I am doing is to copy your data (65 rows) below one another into a temporary worksheet, sort them and copy them back to the origina...

Hi Melinda Try changing this line of codes If IsNumeric(sSheet) Then Worksheets(Val(sSheet)).Activate Exit Sub Else Worksheets(sSheet).Activate ...

Just change your code from Range("A2").Copia to Range("A2").Copy

Hi Dave See if this is what you are looking for. =VLOOKUP(I9-1,E9:F30,2,1) Sunny

Hi Anne Is this what you are trying to achieve? Sunny

Thanks

Hi Anne Although I don't have PQ, I am interested to know what is your expected result from your attachment. It is not too clear for me from you...

Hi David This is a MS Word issue and not related to Excel. So this is not the correct forum to post the question. Sunny

I have done some changes to Philip's file that you downloaded earlier. The assumption is that your product codes are in column A. The macro will...

Please attach an example of your expected result. Include notes if possible. It will help us to understand what you really wanted.

Try downloading the workbook. The workbook contains only 1 button. Click the button, select the required folder and click OK It will create t...

Hi Leah See if this helps. Sunny