Hi guys...
Every month I insert a list of reference numbers...I manualy enter a VLookup formula to extract these entries from my list. I then Filter the different locations (Column B e.g. Noth,South,Midlands)and put those entries on corresponding sheets...
Anybody help with some VB code to automate...
Many Thanks in Advance
Wayne
Every month I insert a list of reference numbers...I manualy enter a VLookup formula to extract these entries from my list. I then Filter the different locations (Column B e.g. Noth,South,Midlands)and put those entries on corresponding sheets...
Anybody help with some VB code to automate...
Many Thanks in Advance
Wayne