eran3185
09-23-2007, 08:39 AM
hi
i build a macro that take al the sheets and copy in a new sheet.
it also put the aheet name at the first row.
then i build a loop that take all the files and do the same thing.
the problems :
1 the loop of the files dont stop ...
2 i want that the sheet name will be at the last column and all over
i build a macro that take al the sheets and copy in a new sheet.
it also put the aheet name at the first row.
then i build a loop that take all the files and do the same thing.
the problems :
1 the loop of the files dont stop ...
2 i want that the sheet name will be at the last column and all over