I have an excel sheet which has a lot of entries of different companies. I have another workbook in which I want to transfer all the entries of a single company ex: Microsoft against which "open"is mentioned in a column. I want to keep updating the new workbook as and when new entries are made. How to directly transfer and keep updating using vba and macros?