Having Error To Consolidate Data Into A Specific Row

Hi,

I am trying to write up a macro to combine some of the information from "Shortage" tab into "Apple" tab under column X.

I got the error "Run-time error '3001'. Arguments are of the wrong type....."

I cannot figure what went wrong. Pls help.

TIA!

First of all you have the field name wrong I believe... you used Prod Order but the field is Prod Ord #
That alone doesn't solve it, there are spaces in the field name and could't get it to work with the apostrophes mysql would use, but if you wrap it in square brackets it will work:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

(I added .Range around I10) is resulting in selecting a range of empty cells (because your last row is ABOVE I10. So the code fails because it is trying to filter by "" If you change I10 to I2 (first row of data), then you won't get errors.

Glad I could help
Thanks for the feedback, rep, and marking the thread as solved!