View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Wilson[_2_] Paul Wilson[_2_] is offline
external usenet poster
 
Posts: 7
Default data from multiple files

Hi,

I wish to run a macro that will use the FileName and SEQNO from an new
workbook to open a FileName and copy a row of data based on the SEQNO, and
paste back in the original workbook on the second worksheet.

I have set the macro already to create the filename and sort based on the
filename from original data so that all the same filename records that need
to be extracted are together.

I'm a novice and I'm not sure where to go from here.

Cheers
Paul Wilson