I was wondering if anyone had a VBS macro for excel that could do the
following: From a table of external data, sort through the data for a
specific number, export this number and row of contents to a separate
spreadsheet. The spreadsheet would add new values when the external
data is updated. Can someone help me on this one?