Hide rows meeting multiple criteria and search for unique values

[Closed]
Report
Posts
1
Registration date
Thursday November 15, 2012
Status
Member
Last seen
November 15, 2012
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

While hours reading posts and forums have increased my knowledge of VBA in which I can create parts of the following request I am still unable to achieve all of the following in one vba code that would update when the document is opened, any help would be greatly appreciated.

Users assign products to set shelving areas by entering product codes in cells C6:C32 or J6:J32 and the following few coloumns are populated with the product name and stock levels that are populated using vlookup. These products are selected from a linked Master List of products listed in rows C35:1035. The VBA I am trying to accomplish is to shorten the master list by automatically hiding rows in the linked master list from c35:c1035 where coloumn A is "Discontinued" and coloumn J is less than or equal to 0. The additional measure that I was hoping to achieve is to change the row fill colour to red for any items in rows c35:c1035 where coloumn J is greater than 0 and the product code in coloumn B is not already in C6:C32 or J6:J32.

I have spent more hours on this than I care to admit and as mentioned any help is appreciated.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
post a copy of small extractg of data sheet and explainb.

of course filterisng will be appropirate. filtered data can be copied to another location