Hi,
I am a self taught excel user (new to the forum) and am running short on a project I need to do. I am not very familiar with VBA but I don't think there is a way around for my problem. I've looked through plenty of forums and threads but couldn't really find what I wanted (I was unable to modify existing codes to solve my problem).
Problem:
From a frequently updated confidential list of suppliers that contains all supplier info (Sheet1 - I already know how to hide the worksheet with password), I need to show to users only the approved suppliers on an separate list that is automatically updated from the master list and non-modifiable yet sortable (Sheet2 - I'm guessing can be protected but with activated autofilters).
I looked into auto conditional copying and auto conditional hiding but can't figure out which one would work better or work at all...
Both lists are identically formatted and use the same headers. Row 1 to row 4 in Sheet1 have data for "validation lists". The data in the master list starts from row 9 to whichever last row that contains data. The supplier name is in column A, the status is in column B and the rest of the data is in the remaining columns (all need to be shown). The status column is the one that will have the "Approved" condition and it is automatically generated through a series of "if" formulas.
Attached is the file I have for example.
Any help is greatly appreciated, thanks
Guillaume
Bookmarks