Attached ,
I need on sheet 2 all zero % movement summary
Attached ,
I need on sheet 2 all zero % movement summary
I will use ALT F8 to run the macro ,
thus I don't want a button created
I'm not sure what 0% movement is. Which items should be moved? Based on what criteria? First column with a zero? Zero in Column H? Please clarify your criteria
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
column h , look at h12 , that is good stock 70% of it sold out
if h is equal to 0%
throw whole data column a to m to sheet 2
starting row 2 , since row 1 is headers
Last edited by makinmomb; 06-09-2014 at 12:33 PM. Reason: 1
throw everything that is zero
This should work for you.
Please Login or Register to view this content.
Super thanks Alansidman
I needed very badly ,
we have a gigantic sell going on
and there are many dead stocks still
not selling at reduced pricing , we want
to blow them at cut throat prices
This is not urgent but at your free time ,
I want the same macro edit to throw less
than 10%
Last edited by makinmomb; 06-09-2014 at 11:59 PM. Reason: during need be at
Try this:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks