Remain with data of 1 branch rest delete

[makinmomb]

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

[makinmomb]

The logic behind this is to read data per branch
instead of reading one branch with data of 22 branch

[jaslake]

Hi makinmomb

Please include in your Sample File your anticipated results; please explain why.

[makinmomb]

Reason ( a ) stock patches on yellow highlights is by store wise
Reason ( b ) reading by store wise is easier

Attached the file see sheet2 sample for store 18
Attached the file see sheet3 sample for store 11

If it creates all files by stores wise on drive C:\CONSO
( Better option , but the above will do too , only that I will do it 22 times )

[makinmomb]

Attached , skipped attache above

[jaslake]

Hi makinmomb

I don't understand...

Store 11.jpg

Store 18.jpg

[jaslake]

Hi makinmomb

I'm getting a handle on it. Do you want the Stores separated AFTER the Sub Find_Yellow() Code is executed?

[makinmomb]

11 and 18 means that that stock is in more than one location at store number 11 and 18

Yes I want the data separated by stores , you got me closer

[makinmomb]

Those are 18 because there is stock in store number 18

[makinmomb]

Look at the header 1 2 3 4 and so , those are store numbers , and that 11 and 18 ,
I have pulled with formula to tell me where the goods are
In the sample data you have seem one goods at 2 locations ,
in my real data , some stock can be in more than one location that is the reason that SH headers are 5

[makinmomb]

I am already using the awesome program of yours , only that I am using
SAVE AS and doing the cleanup of delete rows

This is little lengthy , I have around more than 20 models of shoes types

[makinmomb]

The save as taking long , i will wait the macro to strip the data

[jaslake]

Hi makinmomb

This Code has been added to "Separate" each Store into it's own Workbook in C:\CONSO. Ctrl + x will execute the Code.

It may take a while to run...

Please Login or Register  to view this content.

[makinmomb]

Jake Thank you very much

It will save so much time
22 x 25 brands and that deleting rows was long

[makinmomb]

Hi Jake , program working too cool

Only one last wish , if you can edit the code
to highlight stock greater than 1 as green

Please

[jaslake]

Hi makinmomb

Replace the Find_Yellow Code with this...

Please Login or Register  to view this content.

[jaslake]

Hi makinmomb

I looked at and reran the Code this evening...doesn't quite work does it?

[jaslake]

Hi makinmomb

Try replacing the Find_Yellow Code with this...appears to work...

Please Login or Register  to view this content.