Results 1 to 18 of 18

Remain with data of 1 branch rest delete

Threaded View

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

    Remain with data of 1 branch rest delete

    This is a fully working program by jaslake

    It highlight yellow on stock gaps and does pink highlight on the rest of zero stocks

    I have 22 branches , reading data for that can be long

    I want an add on to the macro do do the following

    I will write on AC1 say 18 ,
    I want the macro to search 18 on cells X Y Z AA and AB
    If it does correctly on store 18 , then 2 tables will remain
    A12:AC17 and A:24:AC26
    With an empty row between the two tables
    Attached Files Attached Files
    Last edited by makinmomb; 11-07-2015 at 08:21 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to delete unwanted cells & delete the rest
    By annux08 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2015, 05:34 AM
  2. [SOLVED] How to delete some data, but keep rest via macro
    By interested in forum Excel General
    Replies: 21
    Last Post: 10-30-2013, 01:19 PM
  3. Macro : To find word and Select rest after this cell and delete rest
    By Zortabello in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2010, 08:06 AM
  4. Delete text while numbers remain intact
    By JE McGimpsey in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-06-2005, 05:05 PM
  5. Delete text while numbers remain intact
    By Sugar_grrl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 PM
  6. Delete text while numbers remain intact
    By JE McGimpsey in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 04:05 AM
  7. Delete text while numbers remain intact
    By Sugar_grrl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 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