copying to a sheet

[JIM.H.]

Hello,
I have an excel file1 which has
columns "SheetNameInFile2","Desc", "Count" (starting
fromA1). No what I need to do is that find the
sheet "SheetNameInFile2"in file2 and copy "Desc"
and "Count" to this sheet (starting from B2 ). What is
the fastest and easiest way?
Thanks,
Jim.

 

[Frank Kabel]

Hi Jim
do you need a copy or a link between both files/sheets. That is do wou
want to update fille 2 automatically or is this just a one time
procedure

 

[JIM.H.]

Hello Frank,
Each month there will be a new file1 with the name
YYYYMMDD.xls, and need to perform that operation to file2
each month. January starts at B2, so February should
start at B3 in file2. SheetNameInFile2 can be different
in the same file1 and it shows to which sheet the data
goes in file2. This way I am dividing a huge single sheet
in file1 into different sheets in file2.
Thanks,
Jim.