Can't see what is generating the 1004 error.
Database has values in Row 1, Store Names in Col B and Stock totals in Cols C - J
Macro below should find the Col corresponding to C2 in Extract, then copy and paste the Store Names and stock values where they are neither Zero or "n/a", but that generates the Error.
All solutions, suggestions and alternatives welcome as everPlease Login or Register to view this content.
Ochimus
Bookmarks