+ Reply to Thread
Results 1 to 9 of 9

No stock movement macro

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    No stock movement macro

    Attached ,

    I need on sheet 2 all zero % movement summary
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: No stock movement macro

    I will use ALT F8 to run the macro ,
    thus I don't want a button created

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,873

    Re: No stock movement macro

    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

  4. #4
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: No stock movement macro

    column h , look at h12 , that is good stock 70% of it sold out

  5. #5
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: No stock movement macro

    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

  6. #6
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: No stock movement macro

    throw everything that is zero

  7. #7
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,873

    Re: No stock movement macro

    This should work for you.

    Please Login or Register  to view this content.

  8. #8
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: No stock movement macro

    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

  9. #9
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,873

    Re: No stock movement macro

    Try this:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. 12 month stock movement ONE CLICK
    By makinmomb in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-27-2014, 10:20 AM
  2. Report stock movement report in excel 2007
    By sattarsiddiqui123 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-12-2014, 05:35 AM
  3. STOCK MOVEMENT day to day
    By makinmomb in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-10-2014, 12:34 PM
  4. Stock movement DAILY
    By makinmomb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-10-2014, 06:08 AM
  5. [SOLVED] Stock movement columns monthly pulling
    By makinmomb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-03-2014, 04:54 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1