VBA code to hide rows and for Vlookup

Hi,

Can you please assist me with a VBA macro code to my current process to make my data more efficient since I have a large amount of data. I have listed the steps below in order. Please see attachment. Can you please assist?


1 Need to hide all the rows that have "Account Number" range 1-3999
2 Need to hide all rows that have ID "28"
3 Need to hide all rows that have segment "3"
4 If "ID" is "22" AND "Location is "Blank" then State is CA
5 If "ID" is "22" then lookup "Location" AND "Client ID" from Sheet 1 to Sheet 2 and pick up the State and Country from Sheet 2 in column M and N