View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JP[_3_] JP[_3_] is offline
external usenet poster
 
Posts: 168
Default Excel Macro for taking data external data and populating it on a sheet and deleting unwanted data

We need a lot more information to help you, for example

1. What type of external data is it? Access? SQL?
2. What information do you need?


HTH,
JP

On Nov 6, 5:42 pm, wrote:
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?